Sync between databases having different schema RRS feed

  • Question

  • Hi,

    I'm quite new to Sync Framework, but I have quite a challenging task at hand...we are developing an application to sync client/server databases where we need to use HTTP protocol (using services) to access the server database. We have a couple of queries:

    1. Please can someone suggest that what should be the best approach of the provisioning. Also can we create/alter tables on client/server side during provisioning?
    2. If schema of a table is different i.e. columns are mismatched on both local and server database then how can we handle this in sync framework?
    3. One of our requirement is that suppose we have two columns in table on both local and server. Now we want one column as "Client win" and another column as "Server win" in the same table. Please suggest how we can achieve this?
    4. How we can we get no of records those have been synched and also the no of remaining records.

    Any help would be much appreciated.


    Friday, June 17, 2016 11:02 AM