I had a correctly working synchronization provider using SQL 2008 change tracking feature. I wanted to clean my database and did a truncate on some tables, but later I read in the documentation that this could break synchronization because the changes are not tracked.
Whenever I try to sync now I get:
'Unable to enumerate changes at the DbServerSyncProvider for table 'Manufacturer' in synchronization group 'ManufacturerSyncGroup'.'
I assume this is because I truncated the server tables. So my question is, how can I clear all the change tracking data?
Moved byHengzhe LiFriday, April 22, 2011 3:22 AM (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
At this point you have lost some change tracking data on server so the client can not continue to sync. To get back to a clean sync state you will have to re-initialize the client. One way to do it is to create a new sdf file and sync from server. You will get all the data from the server again and then start getting incremental data.