Geek Answers Handbook

Sync nightmare - can merge replication (or RDA) be used between two instances of SQL CE without IIS?

We encounter the following issue related to synchronizing the following items:

  • 1 Centralized Server (IIS / MSSQL 2005)
  • Many client WPF clients distributed by ClickOnce
  • Many mobile clients - (Windows CE)

alt text http://img502.imageshack.us/img502/8246/deployment.png

With these thorny restrictions:

  • All synchronization relationships are bidirectional.
  • desktop and mobile sites require offline mode.
  • mobile nodes cannot synchronize with the central server, but must synchronize with the nodes of the desktop computer via USB. Desktop hosts act as a server for mobile clients, not a central server. Updates from mobile nodes should then be distributed to the central server due to synchronization with the desktop and subsequent synchronization of this desktop with the central server. uv

Nastya.

To synchronize the desktop and server, we know that we can use Merge Replication - the server, which is the provider, the desktop as a subscriber, everything is fine. BUT, what about the synchronization of mobile and desktop nodes? It seems like Desktop cannot be a publisher without SQL Server + ISS, right? We can deploy MSSQL CE only on the desktop.

, node , ? , Merge - , - .

, RDA Merge Replication - , , , MS Sync Framework.

, , ?

,

UPDATE: MS Sync Framework, !

+5
2

, , , RDA/Merge Replication . Microsoft ( ), 100% , ( Windows Mobile).

, , , , , . , , , , RDA , . , , , , , , , . , RDA -.

, , ​​ RDA ( 2 ), ( ).

: , , ( Microsoft) , , : , , USB- ( , Windows Mobile ActiveSync), .

, , , MS Tech - ( ): ", - ".

+7

( ) Microsoft Framework 2.0. , , SQL Server Compact. .

+1

More articles:


All Articles