In this paper published by Samuel A. Ajila and Ahmed Al-Asaad from Carleton University in Canada, address concerns with synchronizing a SQL server database for mobile users while off-line. SQL Server has three features to help. They are Remote Data access, Merge replication, and MS Sync Services. Some of the problems that the business experienced are that multiple subscribers (clients) may potentially update the same data at various times and propagate those changes to the publisher (server) and to other subscribers and that there is a need to detect and resolve these conflicts. They conclude that using the merge replication function is best suited for this company.
It is interesting to know that MS SQL Server can be used for more than just storing data and that there are several functions within SQL Server to help with this problem each having its benefits.
I am amazed how much functionality CA Erwin and SQL Server contain. I am also daunted by the fact that there is so much to learn and use in these softwares.
Ajila, S.A. & Al-Asaad, A. (Aug 2011). “Mobile databases – Synchronization & conflict resolution strategies using SQL server.” Information Reuse and Integration (IRI), 2011 IEEE International Conference on Print. vol., no., pp.487-489. doi: 10.1109/IRI.2011.6009598