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
Windows Azure Sync Service Sample
Walkthrough of Windows Azure Sync Service Sample
SQL Server to SQL Azure Synchronization
SQL Azure to SQL Azure Synchronization
How to Sync Large SQL Server Databases to SQL Azure
Extending SQL Azure data to SQL Compact using Sync Framework 2.1
Extending SQL Azure data to SQL Compact using Sync Framework 2.1 – Video
SQL Server to SQL Azure Synchronization using Sync Framework 2.1
SQL Server to SQL Azure Synchronization using Sync Framework 2.1 – Video
If you have any question or clarification, feel free to post them on the SyncFx – Microsoft Sync Framework Developer Discussions