Thursday, January 20, 2011 4:38 PM
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
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?
Sunday, January 23, 2011 2:06 PMModerator
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 PMSync 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
- Proposed As Answer by María del Mar Alvarez RohenaMicrosoft Employee Thursday, February 03, 2011 6:53 PM