Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Sync framework in Azure Web Role RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

     

    Regards

    singhhome
    Saturday, June 5, 2010 6:43 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    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.

    thanks,

    Jin

    Monday, June 7, 2010 5:02 PM
    Answerer