Sync Framework and Change Tracking MetaData RRS feed

  • Question

  • 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?

    Thursday, January 20, 2011 4:38 PM

All replies

  • 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).

    Sunday, January 23, 2011 2:06 PM
  • 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
    Thursday, February 3, 2011 6:53 PM