Sign in
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
> 
Sync Framework and Change Tracking MetaData

Proposed Answer Sync Framework and Change Tracking MetaData

  • Thursday, January 20, 2011 4:38 PM
     
     
    Sign In to Vote
    0

    Is is possible to use the Sync Framework and NOT use Change Tracking nor any type of metadata?

    Two scenarios will work for me:

    1.  Full copy of the server DB (subset of tables only) to local SQL Server CE at application startup

    - OR-

    2.  Update the local SQL Server CE with incremental changes

    - BUT -

    Requirement is to NOT have any server-side metadata and NOT to use SQL Server Change Tracking.  Client-side metadata would be OK.  No upload back to the server is required.  What's the best way to accomplish this?

     

All Replies

  • Sunday, January 23, 2011 2:06 PM
    Moderator
     
     
    Sign In to Vote
    0

    you can try just grabbing a snapshot of the server data every synch, check out how to get a snapshot using the offline provider. if you dont have deletes to synchronize, you can getaway without any metadata on the server side using the offline providers (deletes are tracked in a tombstone table).

     
  • Thursday, February 03, 2011 6:53 PM
     
     Proposed Answer
    Sign In to Vote
    0
    Sync Framework does not use SQL Server Change Tracking mechanism, however it does require to have both client- and server-side sync metadata for its own change tracking mechanism. 
    Maria del Mar Alvarez Rohena Microsoft Sync Framework