Covering SQL Azure Data Sync and Microsoft Sync Framework
SQL Azure Team Blog
Sync Framework Developer Center
JuneT - Idle Thoughts
Liam's Cloud Data Service Blog
The Windows Azure Sync Service Sample is a complete sample that shows you how to extend the reach of your data to anyone that has an Internet connection. The sample uses Microsoft Sync Framework 2.1 deployed to a Windows Azure Hosted Service, so your data extends even to users who have a poor or intermittent connection because the data needed by the user is kept on the user's local computer and synchronized with the server database only when needed.
The typical scenario for this sample is when you have data that is stored in a SQL Azure database and you want to allow remote users to have access to this data but you don't want to allow users to connect directly to your SQL Azure database. By creating a middle tier that runs as a Windows Azure Hosted Service, client applications connect to your hosted service, and the service connects to your SQL Azure database, providing a layer of security and business logic between the client and the server. Client applications can create a synchronization relationship with your server database, take their data offline, and synchronize changes back to the server database when a connection is available. In this way, client applications operate seamlessly even when the Internet connection is unreliable.
Why Deploy to Windows Azure Hosted Service?
Deploying Sync Framework in a middle tier component as a Windows Azure Hosted Service gives the following benefits:
The sample is a 3-tier application that includes these components:
For a complete walkthrough of the sample, see Walkthrough of Windows Azure Sync Service Sample.
Any updates on an potential sync provider for azure tables ?
Sorry we do not have any plans to create a sync provider for azure tables that we can talk to at this time.
This example does not work for me.
Whenever I open the solution, Visual Studio 2008 freezes, presents the following error and crashes without me being able to do anything:
"A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Shared Memory Provider, error: 40 - Could not open a connection to SQL Server)"
I have SQL Server 2008 Express R2 installed. But I would think that such an example should not crash just because some server isn't there - before even running the example
This means I cannot even get to point (3) of your build guide.
Will this sample work unchanged in MS SyncFx CTP 4.0 or are there changes needed?