locked
SyncFx 2.1 ClientWins & ServerWins RRS feed

  • Question

  • How can i deploy ClientWins or ServerWins scenario (MSSqlServer 2k8 <--> MSSqlCe) with Sync Framework 2.1. In older SyncFrameworkversion SqlCeClientSyncProvider includes a ConflictResolver property for that purpose but in 2.1 this property is missing in SqlCeSyncProvider.

     

    PS: Can't find forumcategorie "SyncFx - Microsoft Sync Framework Developer Discussions"

    • Moved by Robert Breitenhofer Wednesday, November 3, 2010 4:02 PM English instead German (From:Für Entwickler: SQL Server)
    Wednesday, November 3, 2010 1:35 PM

Answers

  • Hi,

    For all 2.1 collaboration providers including SqlCeSyncProvider, ApplyAction.Continue (default conflict apply action) is equals to LocalWins, and ApplyAction.RetryWithForceWrite is equals to RemoteWins.

    Thanks,
    Dong


    This posting is provided AS IS with no warranties, and confers no rights.
    Thursday, November 4, 2010 3:13 AM

All replies

  • Hi,

    For all 2.1 collaboration providers including SqlCeSyncProvider, ApplyAction.Continue (default conflict apply action) is equals to LocalWins, and ApplyAction.RetryWithForceWrite is equals to RemoteWins.

    Thanks,
    Dong


    This posting is provided AS IS with no warranties, and confers no rights.
    Thursday, November 4, 2010 3:13 AM
  • Hi,

    thanks for your answer. This is what the 2.1 docu says, but it doesn't work in delete scenario.

     

    My scenario:

    Database with 2 tables, products and orders. Like in sync 2.1 tutorial (http://msdn.microsoft.com/en-us/library/ff928494%28v=SQL.110%29.aspx).

    Client A and Client B and the Server have Product Laptop. Client A add an order to product "Laptop" and synchronize with SqlServerDB. Client B delete product "Laptop" and  try to synchronize. Client B get ApplyChangeFailed on SqlCeSyncProvider with DbConflictType.ErrorsOccurred. Because product "Laptop" was deleted and therefore orders can't add to sqlcedb because our foreign key constrain from order to products. How can i restore Product "Laptop" on client B without delete and reload the complete client database, or get out of sync?

    Thanks a lot!

    MaStoi

    Thursday, November 4, 2010 8:51 AM