Mobile databases - Synchronization & conflict resolution strategies using SQL server

This paper presents the synchronization and conflict resolution for Transport Canada's RSIG (Rail Safety Integrated Gateway) system. In this work, we have designed and developed a comprehensive solution to address the challenges of a Disconnected Mode problem in the RSIG system. The proposed solution is based on Microsoft SQL Server database technology. SQL Server database provides three types of replications-transactional, merge, and snapshot. Our solution is based on merge replication. Merge replication is used for mobile application or distributed server applications with possible data conflicts. This solution could further be applied to the disconnected mode based architecture used by retail wholesalers.