Can we sync two database tables with different schema? RRS feed

  • Question

  • Could we sync two databases which have different schema e.g. I have a table with 10 columns and the other database is sql compact on hand held device with only 3 columns. Can I sync these 2 even though they have different schema?
    Friday, November 26, 2010 6:05 AM


  • Yes, you can use column filters in your scope definition, so that only a subset of columns sync down from the server to the client. If you use the SyncSvcUtilHelper tool to provision your database, you can use it to select tables and columns you want to sync.

    Friday, November 26, 2010 6:18 AM