Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
How to handle conflicts after sync ends? RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote
    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