Friday, December 04, 2009

Synchronizing with a cloud database

In fortifying and solidifying its relational cloud database service-SQL Azure, Microsoft has come up with a new tool, the Microsoft Sync Framework Power Pack for SQL Azure November CTP. All that you need to do is to click and presto, you are in sync.

This tool [SQL Azure Data Sync Tool for SQL Server] makes synchronizing SQL Azure with a local server that much more efficient (compared to force fitting ADO.NET) and that much more reliable.This power pack provides the SqlAzureSyncProvider that automates much of the synchronizing task, that is, a wizard will step in, and take charge. However you may need to keep your SQL Server Agent up and running and happy.

My Experience with this tool:

It's a pretty neat tool except that it did not install the client template in my Visual Studio 2008 SP1(go to bottom of the posting). The database syncronization works like a Swiss clock. The tool needs to create a scope for synhronization. If the two databases (one on SQL Azure and the other on site) exist then the database on SQL Azure must be dropped and a schema is created first time you run the sync program. Run it again and you see the data. Make sure the SQL Agent Service is well oiled.

You want my other syncronization articles. Here they are:

Added after first post:

A forum posting resolved this issue:
The template is visible if you were to create a C# application rather than a VB.NET application

Another update 12/6/2009
The wizard throws a exception when you try to connect to SQL azure in a C# project

Final update 12/08/2009
By design the template is not included in VB.NET
There is an error in the first window of the wizard
Review the threads here.

No comments: Protection Status