>I have two identical programs. Each residing on to seperate servers. I need to move some data from one server to another. What happen was All of my users were using the foxpro program on production server. One of my user however was still pointed to an old production server and had posted entries in one of the tables. I need to move a set of data to my production server database from old production server. Is there a quick way to do this or is there anything tricky about. I will have to use insert into command because this is in vfp7 using a nextid.prg to create primary key.

Hi, Nick

As far as the primary keys don't get duplicated, there shouldn't be any problem.

Maybe you can do a local copy of the two datasets and make a tast before doing it "live", just in case anything doesn't goes as you think in the first run.

Hope this helps,