Synchronization of data sources with Microsoft Sync Framework

摘要

More and more companies are opting for informatisation of field operations. Regardless of the outcome of the integration, looking from a business perspective, all mobile applications technically face the problem of safe access to the central database without communication failures. udIn this thesis, I have explained and implemented synchronization of various data sources, through which the end-users can transfer a subset of centralized data to their mobile devices. Enriched information from the field is later, again by means of synchronization, transferred back to the central database. Synchronization between the consuming devices and server is implemented via WCF service. Mock solution is implemented using Microsoft Sync Framework with MS SQL Server 2008 R2 and MS SQL Server CE 3.5 acting as server and client database back-ends respectively. Stored procedures, which are used during the synchronization process, are explained in detail. Since this work is based on a real-life project, it also includes information on security, debugging and unit testing.