SQL Azure Data Sync Service Preview Update

Gregory Leake has just posted the third service update/refresh for the SQL Azure Data Sync Service Preview.

Most notable among the updates is the availability of the Data Sync Service on all Azure Data Centers and support for synchronizing self-referencing tables.

The update/refresh contains the following updates:

  • Data Sync servers can now be created in all Windows Azure data centers, enabling Data Sync servers to be created close to the SQL Azure databases for the best possible performance.
  • The Data Sync section of the Windows Azure portal is now localized in ten languages.
  • Miscellaneous fixes and numerous usability improvements including:
    • Progress indicators are now available in the log for long running synchronizations.
    • Error messages have been improved to better help you troubleshoot problems.
    • Synchronization of self-referencing tables is now supported.
    • A new version of the Data Sync Agent is available in the Download Center and it is highly recommended that existing agents are updated to the new version (available here).

This is on top of the previous two service updates containing the following:

  • Addressed the issue that sometimes led to failed syncs for narrow tables with a small number of columns.
  • Allow logins when either username@server or just username are specified.
  • Column names with spaces are now supported.
  • Columns with a NewSequentialID constraint are converted to NewID for SQL Azure databases in the sync group.
  • Both Administrators and non-Administrators are able to install the Data Sync Agent.

See: Announcing SQL Azure Data Sync Preview Refresh – Windows Azure – Site Home – MSDN Blogs



  1. When is going to be the final release to production use.

    1. i dont work for Microsoft, so i don’t have information on that other than a hunch. I guess it wont be long. If you look at the SQL Azure Data Sync Wiki,it has a note that they are migrating the contents to MSDN. So i guess theyre preparing to launch it. My bet is maybe around SQL 2012 launch?

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: