Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Reinitialize change tracking RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hello,

    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 by Hengzhe Li Friday, April 22, 2011 3:22 AM (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
    Friday, April 24, 2009 9:09 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi,

    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.

    thanks
    Sudarshan
    Development Lead , Microsoft
    Wednesday, April 29, 2009 10:31 PM
    Moderator