Synchronizing with SQL Azure using Sync Framework


Finally found time to do some blogging tonight.

It’s been a while since my last blog post since I’ve been busy getting across the line the first phase of a project am working on. Plus, I’ve spent some time  configuring my new replacement laptop and new SSD (an OCZ Vertex 3 Max IOPS that requires jumping thru hoops just  to get a stable Windows 7 base install, see http://www.ocztechnologyforum.com/forum/forumdisplay.php?254-Vertex3-Agility3-Solid3-support-and-discussion-forum and you’ll know what I meant by jumping hoops )

Moving on, I’ve been seeing some questions lately with people asking how to synchronize databases with SQL Azure. In some cases people are directed to the SQL Azure Data Sync Service. Unfortunately, the SQL Azure Data Sync Service is just in CTP stage at this moment (CTP2 as of this writing, with CTP3 supposed to be available this summer, see Using Microsoft SQL Azure with On-Premises Data: Migration and Synchronization Strategies and Practices | Tech·Ed North America 2011 | Channel 9 for what may be coming in CTP3 ). While CTP3 may be available soon, it also means that the production release may not be available anytime soon.

Fortunately, for those who can’t wait for SQL Azure Data Sync Service’s production release, there’s Sync Framework 2.1. One of the major highlights of the 2.1 release is the enhancement of the SqlSyncProvider to support SQL Azure. This effectively allows developers to use the same provider to provision and code synchronization for SQL Express, SQL Server and SQL Azure.

I thought about writing a blog post on Synchronizing with SQL Azure but after going thru links that I’ve bookmarked before, there is not much that’s not written on how to go about doing it. So I’ll just list down here the links to various code samples/walkthroughs available.

Here you go:

How to: Configure and Execute Synchronization with SQL Azure
http://msdn.microsoft.com/en-us/library/ff928617(v=SQL.110).aspx

Windows Azure Sync Service Sample
http://code.msdn.microsoft.com/Windows-Azure-Sync-Service-60293622

Walkthrough of Windows Azure Sync Service Sample
http://social.technet.microsoft.com/wiki/contents/articles/walkthrough-of-windows-azure-sync-service-sample.aspx

SQL Server to SQL Azure Synchronization
http://social.technet.microsoft.com/wiki/contents/articles/1591.aspx

SQL Azure to SQL Azure Synchronization
http://social.technet.microsoft.com/wiki/contents/articles/sync-framework-sql-azure-to-sql-azure-synchronization.aspx

How to Sync Large SQL Server Databases to SQL Azure
http://blogs.msdn.com/b/sync/archive/2010/09/24/how-to-sync-large-sql-server-databases-to-sql-azure.aspx

Extending SQL Azure data to SQL Compact using Sync Framework 2.1
http://blogs.msdn.com/b/sync/archive/2010/09/13/extending-sql-azure-data-to-sql-compact-using-sync-framework-2-1.aspx

Extending SQL Azure data to SQL Compact using Sync Framework 2.1 – Video
http://channel9.msdn.com/Blogs/LiamCavanagh/Extending-SQL-Azure-data-to-SQL-Compact-using-Sync-Framework-21

SQL Server to SQL Azure Synchronization using Sync Framework 2.1
http://blogs.msdn.com/b/sync/archive/2010/08/31/sql-server-to-sql-azure-synchronization-using-sync-framework-2-1.aspx

SQL Server to SQL Azure Synchronization using Sync Framework 2.1 – Video
http://channel9.msdn.com/blogs/liamcavanagh/sql-server-to-sql-azure-synchronization-using-sync-framework-21

If you have any question or clarification, feel free to post them on the SyncFx – Microsoft Sync Framework Developer Discussions

Cheers,

JuneT

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: