Category SQL Azure Data Sync

Things You Need To Know About SQL Data Sync Service

The following is a collection of the things I’m usually asked, things that I usually encounter and clarify in forums and some other little known facts. So, I thought I’d post it here and just update it from time to time. 1. Provisioning Before a member database can participate in synchronization, the Data Sync Service […]

SQL Azure Data Sync Preview Service Update

Microsoft have just released a new service update for the SQL Azure Data Sync Service. Most notable of this release is the ability to update the Dataset definition for a Sync Group. You can now add/remove a table/column from a Dataset with some limitations in that you cannot change a column’s data type, add/edit/remove a […]

SQL Server 2012, SQL Express 2012 LocalDB, Sync Framework, Sync Framework v4 and SQL Azure Data Sync

Apologies for the blog post title, I just couldn’t find a better way to summarize what this post is so I just listed all the products that this post is all about. I noticed that over the last couple of weeks, there’s a few search engine referrals to this blog having ‘sql 2012 localdb sync, […]

MS Patterns & Practices : Building Hybrid Applications in the Cloud on Windows Azure – Published

The Microsoft Patterns & Practices team has just published the third volume in a series on Windows Azure. This guide focuses on the common challenges encountered when building, deploying and operating applications that run partly in the cloud and partly on-premises. Of particular interests to me is the 2nd Chapter where data synchronization options are […]

Sync Framework Scope and SQL Azure Data Sync Dataset Considerations

In Sync Framework, the tables to be synchronized including the columns to be included in synchronization and the corresponding filters are defined in the scope definition. In SQL Azure Data Sync Service, the counterpart for this is the Sync Group’s Dataset definition (which is a Sync Framework scope internally, with SQL Azure Data Sync Service actually built […]