Synchronizing databases

[Puiu]

Hello everyone,

 

I am creating a small application that will use SQL Server 2005 Express as database.

This little piece of software will be used in different locations and at the end of the day it will have to synchronize the data from all the places where SQL Server will be installed. The next day all the locations' databases will contain the same information.

 

Working in real time on the same database is not an option due to the possibly large distances between the locations.

 

I haven't done this before, so i am asking you how to do this...what would be the best approach?

 

Thank you!

[Gill Bates]

This will depend on what you actually mean by "synchronize".

 

If you mean take everything from DB A and put into DB B and vice versa, then it's a cake walk. You simply need to spin through the rows that are after a certain date/time threshold and insert them in the other database. But if you mean check everything in DB A against everything in DB B and see if we need to merge/update/create/delete, then you have a big task on your hands.