Updated SQL Azure Data Sync Preview

Seems like a new release of the SQL Azure Data Sync Service has made it to the Azure Portal.

From http://msdn.microsoft.com/en-us/library/hh456372.aspx :

New in this Release


SQL Azure Data Sync Icon Microsoft SQL Azure Data Sync is built upon the Sync Framework. SQL Azure Data Sync enables you to easily create and schedule synchronizations between SQL Server and SQL Azure databases from the SQL Azure Data Sync web portal without the need to write a single line of code.Prior to the version 1 release the SQL Azure Data Sync service is free (there are Windows Azure charges though). SQL Azure Data Sync Preview is the current release and introduces the following new features and capabilities.

What’s New in the SQL Azure Data Sync Preview?


SQL Azure Data Sync no longer hosts its own web site. It is now accessed from the Windows Azure Management portal – https://windows.azure.com/default.aspx.


If you’re familiar with previous previews of the Data Sync service the first thing you’ll notice about this Preview is the completely redesigned UI. The new UI is task oriented and includes tutorials that walk you through creating a new sync group. For more information see Create Sync Group.

The new UI also includes integrated Help. Click the ? on any screen for context sensitive help.

Sync Direction

As you create a sync group you assign a sync direction to each member database individually. This makes it easy to move only as much data as is necessary. For example, you could create a sync group that takes the sales data from each regional office and synchronizes it to the hub and then from the hub to corporate headquarters. This minimizes data movement by eliminating the round trip with each regional office sending its sales data and receiving sales data from the other regional offices.

  • Bi-directional
    Data changes in the member database are written to the hub and then all changes written to the hub are written out to the member database.
  • To the hub
    Data changes in the member database are written from the database to the hub.
  • From the hub
    Data changes in the hub are written out to the member database.

For more information see step 3 in the Add a SQL Server Member Database section in the Add a SQL Server Member Database topic.

Sync Dataset

SQL Azure Data Sync Preview provides for much more granular dataset definitions than before. With this Preview you can

  • Select the particular databases you want to synchronize.
  • Select specific tables to synchronize.
  • Select specific columns within each table to synchronize.
  • Define row filters so that only the rows that meet the filter requirements are synchronized.

For more information see the Select the Tables, Columns and Rows to Synchronize section in the Configure a Sync Group topic.

Conflict Resolution Policy

Whenever the same data is changed in two or more places between synchronizations a data conflict exists. Which change do you keep and which do you discard? In this Preview we make it possible for you to select the conflict resolution policy.

  • Hub Wins
    The first change written to the hub is the change that is kept. All other changes to the field are discarded.
  • Client Wins
    Each client change is written to the hub overwriting prior changes. Thus the last change is kept and all prior changes are discarded.

The SQL Azure Data Sync Wiki has likewise been updated over the last couple of days. See: http://social.technet.microsoft.com/wiki/contents/articles/sql-azure-data-sync-overview.aspx

Here’s some screen shots.

More details to come when I get around playing with it tonight.




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 )

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s

%d bloggers like this: