December 27, 2005 at 2:59 pm
Hi All,
We have our current database in FOXPRO and now we are currently trying to move in to SQL and we are planning to implement in one department currently. Is there any way to synchronize FP and SQL tables like if the FP tables got updated it should update the SQL table automatically and vice versa so that we can compare both the tables and make sure the application is running without any problem until we move fully in to SQL since the rest of the applications depends on the FP database.
Thanks
Senthil
December 28, 2005 at 5:52 am
AS VFP allows the use of triggers, that is probably the best way. Make sure that the VFP trigger does a full compare of the records in both the dbf and the SQLServer table so that any update conflicts can be handled.
Tony
December 28, 2005 at 9:39 am
We did this years ago and just for an hour had everyone double entry things. then we shut down for 10 minutes, copied the VFP database, and went back to work. The IT guys then compared the dbs to see if all the tables had the same rowcounts and a random sampling of updated records had the correct data.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply