SQL Azure Data Sync Update

It’s been a while since we announced SQL Azure Data Sync CTP2 and I wanted to provide an update on how CTP2 is progressing as well as an update on the service in general.

Late last year at PDC we announced CTP2 and started accepting registrations for access to the preview release.  In mid-December we started providing access to the service and have continued to work our way through the registrations, adding more users.  We recently made a few updates to the service as a direct result of feedback we’ve received; bug fixes and a number of usability enhancements.

We’ve seen huge interest in CTP2, so much so that we may not be able to give everyone who registered access to the preview.  We are going to continue to process registrations throughout March, but for those of you that do not get access we will be releasing CTP3 this summer and will make that preview release open to everyone.  Feel free to continue to register for CTP2 as that will allow us to email you as soon as CTP3 becomes available.

While on the subject of CTP3, here are some of the new features planned:

  • A new user interface integrated with the Windows Azure portal.
  • The ability to select a subset of columns to sync as well as to specify a filter so that only a subset of rows are synced.
  • The ability to make certain schema changes to the database being synced without having to re-initialize the sync group and re-sync the data.
  • Conflict resolution policy can be specified.
  • General usability enhancements.

CTP3 will be the last preview, before the final release later this year.  We’ll announce the release dates on this blog when available.

Finally, here are some links that may be helpful:

Best wishes, Mark

Comments (19)
  1. Sudhanshu Hate says:

    While migrating SQL Server 2008 R2 based database to SQL Azure storage using SQL Data Sync CTP2, observed that the database constraints are not copied from on-premise to off-premise DB (SQL Azure). How can i get this feature without having to manually script the constraints and execute the script. Any plans to support this in future version of SQL Data Synch? am i missing something.



  2. SQL Ranger says:

    Can Data Sync be used to synchronise SQL Server databases? So Azure is not in the picture at all? So for example use this technology to synchronise SQL Server Enterprise Edition with 10 SQL Server Express Edition databases?

  3. Manoj Nair says:

    There is an option available in Sync Framework 2.1 to sync between on-premise and SQL Azure databases. How this will be different from the Data Sync tool and when to prefer which?

  4. Dan KSi says:

    My question is similar to the previous two.  Is it possible to sync an on premise SQL Server 2008 R2 express database with SQL Azure using CTP2/3?  Thank you.

  5. Craig says:

    Any news on CTP3? What about a final release? It seems like very long release schedule, a year between CTP2 & 3.

  6. Same question as Dan above: Is it possible to sync an on premise SQL Server 2008 R2 express database with SQL Azure using CTP2/3?

    Any help on this topic would be great!

  7. Mike Hughes says:

    Is it possible to sync SQL Azure with a local SQL Server CE with either CTP2 or CTP3?

  8. pini krisher says:


    When the serive will be available agein?

  9. Vincent Cotton says:

    Any new?  It's been a long time since we have had a status update.  Getting nervous that this is being cancelled after we have so much invested.

  10. JuneT says:

    Vincent – afaik, the team is still busy working on CTP3.

  11. JuneT says:

    Dan/Eric – internally, Data Sync uses Sync Framework's SqlSyncProvider, so it should work i think it should work with SqlExpress.

  12. JuneT says:

    Mike – CTP2 doesnt work with Sql CE. I dont think it's going to be in CTP3 either. The product being in CTP, things may change though. you might want to suggest that feature at : http://www.mygreatwindowsazureidea.com/…/44459-sql-azure-data-sync-feature-voting

  13. JuneT says:

    Manoj – Data Sync is targeted as an out-of-the-box, configure and run type of Sync similar to Sql Replication. As such, you are limited to whatever features is available OOTB in Data Sync. For example, the service is hosted in Azure and i doubt you can move the service on-premise or where you want it to be. The current CTP doesnt support Sql Ce unlike Sync Fx and has limited support in terms of conflict handling (its in CTP so things may change).

    Sync Fx on the other hand allows you to setup and configure your sync whichever way you want.

    Between the two, its a choice between ease-of-setup vs flexibility.

  14. Apologies for the long delay between updates.  Rest assured we are still working on CTP3 and will have it available soon!

    For sync of on-premises databases we do support SQL Server Express, but will not support SQL Server Compact for V1.

  15. DanielS says:

    Is it possible to use Sync Framework to sync a SQL Server 2008 warehouse db with different customer databases in other companies which use SQL Server 2005 and SQL Server 2008? This has to go via a firewall. Or is it better to use SQL Server Web Replication to achieve this? Or is there even another option? Thanks

  16. JuneT says:

    @DanielS – Yes, you should be able to use Sync Framework to sync with Sql Server 2005 sp2 and Sql Server 2008. You can write code for Sync Framework to use WCF if firewalls are an issue.

    Sync Framework is an SDK so you have to write code for it. I understand Sql Server Web Replication is more a configuration approach. Sql Azure Data Sync on the other hand is a configurable sync service in the cloud.

    If you can't write code and just want an OOTB configurable option, the SQL Web Replication or Data Sync is probably the best option for you, otherwise, you can write the sync code using Sync Framework.

  17. Richard Tappenden says:


    Any news on CTP3? If it does allow Schema synchronisation too, then it'll be the tool we use when migrating to azure. If not, we need to rethink our strategy.

    Any updates would be appreciated.



  18. JuneT says:


    Looks like there is  a new release already. Check out the wiki at: social.technet.microsoft.com/…/sql-azure-data-sync-overview.aspx

    from the looks of it, no schema syncs still.

  19. Hi

    We just announced the final preview release of Data Sync today; check it out in the Windows Azure Portal.

    As JuneT states, no schema sync in the release.

    To vote for schema sync or request any other features, please visit the feature voting forum – http://www.mygreatwindowsazureidea.com/…/44459-sql-azure-data-sync-feature-voting

    Regards, Mark

Comments are closed.

Skip to main content