Seems like a new release of the SQL Azure Data Sync Service has made it to the Azure Portal.
New in this Release
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.
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.
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.
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.
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.