locked
n-tier, custom transfer protocol for synchronizing SQL Server CE <--> SQL Server RRS feed

  • Question

  • Hello!

    I'm looking into using the Sync Framework in a n-tier setup for syncing data between client and server. I would like to use a custom transfer protocol as the transport for the data. I'm primarly intrested in implementing database sync between SQL Server CE (Windows Mobile) and SQL Server.
    From what I've read so far the Sync Framework way to implement this is a Standard Custom Provider which should act as a proxy (Proxy Provider).

    According to "Implementing a Standard Custom Provider" (http://msdn.microsoft.com/en-us/library/bb902826.aspx) I need to implement KnowledgeSyncProvider, IChangeDataRetreiver and INotifyingChangeApplierTarget.
    However another example I've found "Database Sync - SQL Server and SQL Server Compact" (http://code.msdn.microsoft.com/Release/ProjectReleases.aspx?ProjectName=sync&ReleaseId=3422) doesn't use the IChangeDataRetreiver and INotifyingChangeApplierTarget from what I can see. So I'm thinking that maybe I dont need to implement them?

    The main question I have is; how do I implement the synchronization over the custom protocol in the easiest way?

    I'm thinking something like this but I'm not sure that it would work:
    Client
    - Implement a custom provider inheriting KnowledgeSyncProvider. This proxy should forward data to an SqlSyncProvider on the server.
    Server
    - Implement a custom provider inheriting KnowledgeSyncProvider. This proxy should forward data to an SqlCeSyncProvider on the client.


    Best regards
    Thomas

    Wednesday, July 14, 2010 2:49 PM

All replies