Sign in
Microsoft.com
 
Microsoft
 
 
 

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

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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