General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
John-
>I need to sync a table from a database on several computers that are not on a network. Should I just copy the table from computer or should I build a temp table on the disk and update from the temp table. Any thoughts on this will help.
The answer to that question really depends a lot on what the data is. But, in my experience, I never could get away with copying one file over another, if both users are making changes to the table.
Most of us write (and write and write and write) import/merge routines. I suspect you'll need to do the same. Probably copy the to-be-merged file into a temporary location and then go thru the two versions, using whatever algorithm is appropriate for your situation, and compare the changes.
If you'd like to tell us (succinctly) what the data is, then we could help you develop a plan of action, if you like.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only