locked
Use SqlCeClientSyncProvider for Peer-to-Peer Synchronisation RRS feed

  • Question

  • It would save much time if we can use SqlCeClientSyncProvider for Peer-to-Peer Synchronisation bewteen two Sql Server CEs.

    I found changes made by SqlCeClientSyncProvider did not populate Change Tracking information (in __sysChangeTxBsn etc.) at all. So in the case of three peers, you could synchronize peer1 and peer2 and then peer2 and peer3. Peer1 and peer3 would NOT receive changes from each other through peer2.

    Is there a workaround? Does Microsoft will enhance SqlCeClientSyncProvider for this purpose?

    • Edited by Bob H.L. _ Friday, August 28, 2009 6:56 AM typo
    • Moved by Max Wang_1983 Thursday, April 21, 2011 11:34 PM forum consolidation (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
    Friday, August 28, 2009 6:55 AM

Answers

  • Hi Bob,

    MSF V2 has Sync providers for CE that support P2P syncs. If you haven't already please take a look at the CE providers in MSF CTP2. You can build p2p sync between CE instances using these providers.

    thanks
    Sudarshan
    Development Lead , Microsoft
    Monday, August 31, 2009 11:29 PM
    Moderator

All replies

  • Hi Bob,

    MSF V2 has Sync providers for CE that support P2P syncs. If you haven't already please take a look at the CE providers in MSF CTP2. You can build p2p sync between CE instances using these providers.

    thanks
    Sudarshan
    Development Lead , Microsoft
    Monday, August 31, 2009 11:29 PM
    Moderator
  • Glad to see this handy enhancement. Thanks Sudarshan!
    Wednesday, September 2, 2009 5:56 AM
  • Sudarshan,

    Are there guidlines for N-tier peer-to-peer synchronization using SqlCeSyncProvider at both sides?

    In the v2 CTP2 documentation, KnowledgeSyncProvider is mentioned, but it looks overkiil, and there is no example.

    Thx.
    • Edited by Bob H.L. _ Monday, September 7, 2009 3:23 AM fix typo
    Friday, September 4, 2009 6:40 AM