Geek Answers Handbook

Synchronizing data from a local database to a central SQL Server

I have a requirement to synchronize local db data with a central SQL server. Remote users (mainly about 10 people) will use a laptop that will host the application and local db. Internet connection is not 24x7. When there is no connection, the laptop user should be able to make changes to the local database and after the connection is restored, the data should be synchronized with the central SQL server automatically. Synchronization is usually updating data. I reviewed the capabilities of the Sync framework and Merge replication. I cannot use the synchronization structure since I am not an expert in C #. Merge replication requires additional hardware. I believe this is not possible. The solution should be easy to develop and maintain.

Are there any other options? Can SSIS be used in this scenario?

+6
source share
2 answers

I would use Merge replication for this scenario. I am not aware of any additional hardware requirements.

SSIS can do the job, but it does not give you any help out of the box — you would invent the wheel for a very common and complex scenario.

+3
source

idea ... An idea requires an intermediate database (exchange database). In the exchange database, you have tables with data for each direction of synchronization. And using change tracking on db exchange and central.

On the local database side there can be rows with flags:

  • db
  • db
  • ( , ect.)

localdb-exchange db. localdb ( ), db ( ).

db db , .

Trancking !

0

More articles:


All Articles