locked
How to handle conflicts after sync ends? RRS feed

  • Question

  • I'm synchronizing a SQL Server 2008 db with a SQL Express 2008 db using SQL Server Change Tracking and WCF. I need to notify the user when a conflict occurs on the server so the user can take action. All the samples I've seen solve conflicts in the ApplyChangeFailed event by setting the Action property of the ApplyChangeFailedEventArgs argument.

    How can I obtain a list of the conflicts generated after the synchronization ends and how can I resolve this conflicts?

     

    • Moved by Hengzhe Li Friday, April 22, 2011 3:14 AM (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
    Tuesday, May 26, 2009 3:52 AM

Answers

  • Sync Services does not provide out-of-the-box support for this scenario.  It could be written by storing off the conflicting row (which is available to you in the ApplyChangeFailed event) in a "conflicts table".  Outside of synchronization, you can then go back and revisit the conflict and corresponding live row in the database.

    Thanks,
    Phil
    Tuesday, May 26, 2009 4:18 PM