Sign in
Microsoft.com
 
Microsoft
 
 
 

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

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    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

Answers

  • Question
    Sign in to vote
    1
    Sign in to vote

    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