Are you a startup?
Get BizSpark cloud access
Get up to $3,700 of cloud benefits
Don’t have MSDN?
Here’s cloud access
MVP Glenn Berry has put together a guide to getting started with SQL Azure Data Sync. SQL Azure Data Sync is a free tool that allows you to easily create a SQL Azure database, and then synchronize the data periodically (on a table by table basis) with an on-premises SQL Server database.
The post, Playing With SQL Azure Data Synch, provides screenshots and the steps you can take to synchronize your data with SQL Azure.
The SQL Azure Data Synch Developer Quick Start page has instructions and links to the Microsoft Synch Framework 2.0 Software Development Kit (SDK) and the Microsoft Sync Framework Power Pack for SQL Azure November CTP (32-bit) which are needed to make this tool work. Even if you are using a 64-bit version of Windows, you should install the x86 version of the Power Pack. It also gives you a Visual Studio 2008 Template that allows you to take an existing SQL Azure database offline, this new template simplifies the task of creating an offline data cache within SQL Compact.
After you have installed the Synch Framework SDK and Power Pack, you can run the wizard to easily create a SQL Azure database and synchronize your on-premises data with SQL Azure. You have to have SQL Agent available and running on your local instance of SQL Server.
Berry’s blog post walks you though the steps. See Playing With SQL Azure Data Synch,
Microsoft SQL Azure Data Sync provides symmetry between SQL Azure and SQL Server through bi-directional data synchronization. Using SQL Azure Data Sync organizations can leverage the power of SQL Azure and Microsoft Sync Framework to build business data hubs in the cloud allowing information to be easily shared with mobile users, business partners, remote offices and enterprise data sources all while taking advantage of new services in the cloud. This combination provides a bridge, allowing on-premises and off-premises applications to work together.
Bruce D. Kyle ISV Architect Evangelist | Microsoft Corporation