none
Can you select which column to sync with Sync Framework RRS feed

  • Question

  • I notice that with MS Sync, going through the wizard to create the WCF service that will do the sync, you can only choose which table to sync.

    Is it possible to only sync a few columns of the table and not the entire table? It will also create the local sdf file with the whole table structure. I only need a few columns of the table to be displayed in my mobile device.

    Tuesday, May 18, 2010 2:50 PM

Answers

  • Hi,

    You should be able to sync subset of columns by only including the needed columns in the Syn TSQL queries. The side effect is that the changes in unneeded columns will cause the row be synced again because sync change tracking is per row not per column.

    Thanks,
    Dong


    This posting is provided AS IS with no warranties, and confers no rights.
    Tuesday, May 18, 2010 6:39 PM
    Moderator