Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement