none
MSSync Issue - Column Level Tracking RRS feed

  • Question

  • Hi,

    We are working on a project using MSSync framework for a US based customer.

    Our goal is to sync multiple client databases at different geographical location with a  central database server. Our central server has only one database but with multiple schemas (1 schema for each client). Here we are using WCF for server communication with sync application.

    We are facing below challenges while implementing the solution with Microsoft Sync Framework:

    1.        Initially during provisioning/re- provisioning, we were getting deadlock in the database. Then to avoid this issue, we applied a lock on provisioning service. Now it is taking a lot of time as it is now working sequentially.
    2.        We are struggling to find a method to do column level tracking of database updates. For example - For same record, if columnA & columnB is updated on server side at 10:15 and columnA is updated on client database at 10:30 then Sync should pick columnA from client side and columnB from server side as a conflict resolution. Please suggest if there is any approach to track column level updates.
    3.        If the data in any table is too large (>50,000 records) on both sides, when we do the initial sync, it is throwing exception. So please suggest is there any approach for such large data.

    Any help would be much appreciated.   

    Thanks

    Wednesday, February 15, 2017 1:20 PM