For the purpose of synchronizing data in sql server, such as:

1. Synchronize data between servers and client
2. When loss of internet, the client can still work based on the data required to run on the client.
3. When have the internet connection, data from workstations to be synchronized with the server.

To meet these objectives above how to do it with sql server? Or other data synchronization?


Are the clients just normal desktop users? If so you can put sql express on everyones system if your database is under 10 gigs and then have it send back the data to the parent database via SSIS or .Net.

SQL Express does allow users to use any sort of mirroring, or snapshot. It would most likely be heavy on bandwith and you would also run into the issue of users duplicating work so you would have to envoke a rule based system to see who wins.

Data synchronization is the process of establishing consistency among data from a source to a target data storage and vice versa and the continuous harmonization of the data over time.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.