Information générale
Catégorie:
Codage, syntaxe et commandes
Hi William. Synchronizing data is a big job. Rather than spends weeks trying to get something working , it might be cheaper to buy a solution. Here are some ideas:
- you could use a product like SQL Server 7 that supports replication
or
- centralize your database so that both sites us the same data
(fast lines between sites, or a web connection to the database)
>Looking for a little help,
>I have an app that is running at two locations. Both locations are inputting and changing customer data. At the end of the night a data transfer takes place placing a copy of each customer table on each computer i.e. computer A gets computer B's table and computer B gets computer A's. My problem is how do I merge the two tables looking for new and updated records without duplicating anyone's information. If computer A changes Sally's information I want the changes reflected into computer B's. Hope I am clear enough. Thanks for the help in advance.
>
>Bill
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