SQL Azure Data Sync Update

SQL Azure Data Sync Update

  • Comments 19

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

Leave a Comment
  • Please add 5 and 6 and type the answer here:
  • Post
  • 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.

    Thanks

    Sudhanshu_Hate@infosys.com

  • 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?

  • 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?

  • 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.

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

  • 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!

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

  • Hi

    When the serive will be available agein?

  • 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.

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

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

  • 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 : www.mygreatwindowsazureidea.com/.../44459-sql-azure-data-sync-feature-voting

  • 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.

  • 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.

  • 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

Page 1 of 2 (19 items) 12