Sync framework in Azure Web Role RRS feed

  • Question

  • Hi

    What is the best/feasible solution for using syn framework to sync data between SQL server (on premise) with SQL CE (in azure web role). SQL CE only needs to get latest data from SQL server, SQL CE will never sync back data to Sql Server.

    1. Host a WCF service in on-premise server. Azure web role uses ClientSyncProvider to update its SQL CE and uses ServerSyncProviderProxy  to get data from WCF service from on-premise SQL server with SyncDirection.Download.

    2.  Use the sample as provided at http://code.msdn.microsoft.com/sync/Release/ProjectReleases.aspx?ReleaseId=3762.


    I am not sure if either of these can actully be used in my scenario



    Saturday, June 5, 2010 6:43 PM


  • I can see there are a few issues with this solution for your consideration:

    - I haven't heard SQL Ce could be used with Azure web role, please let me know a link to that information if it's existing.

    - To use Sync framework in Azure roles (Web role or worker role), some extra work needs to be done to make it work because Sync Framework is built with COM which is not natively supported in Azure. We will post a sample to show how to make it work when next version of Sync framework is released.

    - Normally using sync framework in Windows Azure (web role or worker role) is to take advantage of SQL Azure so that the data hosted in SQL Azure can serve as a hub to on-premise users.



    Monday, June 7, 2010 5:02 PM