CODEWITHSUNDEEP
c#.netsqlclient-server
Marshal
Marshal

Reputation: 6671

SQL Data synchronization

We have multiple client operating the same software application which has same database structure on their individual PCs. All the clients are offline and at different locations (Not connected by LAN etc.)

Is it possible that, each client pc collects its own data and then server can restore client's back up and get updated with each of the clients data. By updating/restoring the data on server should be merged with all the client's data, so that server admin can view activity at each client side.

I hope I am clear.

Thank you very much in advance.

Regards.

Edit: We will be using SQL Server Express 2008 Edition.

Upvotes: 0

Views: 975

Answers (1)

markus
markus

Reputation: 602

As @Dennis mentioned you could use Microsoft Sync Framework. Synchronization is a non-trivial task because of many factors like conflict handling, change detection, timestamp synchronization.... The Microsoft Sync Framework does that all for you.

There are several other Frameworks that do synchonization. See OpenSync or SymmetricDS.

Upvotes: 3

Related Questions