SQL Data Sync (SDS) – Cloud based data synchronization tool


Data on the go is the latest topic that you will see from Microsoft, going forward majority of data can be accessed from anywhere in the world using cloud-based deployments.

SQL Data Sync (SDS) (where the current release is a preview) is a cloud based data synchronization service that is built upon Microsoft Sync Framework technologies. This tool is helpful to build a bi-directional data synchronization process for your data management capabilities between SQL Server instances (on-premise) and cloud databases (SQL Azure).

In a nutshell SDS is useful to perform:

  • Cloud to cloud synchronization
  • Enterprise (on-premises) to cloud
  • Cloud to on-premises.
  • Bi-directional or sync-to-hub or sync-from-hub synchronization

How to do it?

The data synchronization can be performed using a method of create sync groups which define the databases and database objects (tables and columns) to synchronize as per the defined schedule. It is compulsory to obtain 1 SQL Server instances which serves as the sync group hub which works similar to hub-and-spoke topology. You can you the on-premise SQL Server instance to hold such information or a central server which is key for DBA services.

If in case of Windows Azure SQL data sync it is recommended to use Windows Azure management portal link. Under that portal you can refer to the SYNC tab which will be available only when you have one or more sync groups created. You can refer to  How To: Create a Sync Group (SDS) for more information.

The initial thought is to check the  System Requirements for SQL Data Sync (Preview) that can highlight the essentials.  Moreover I also refer these links which are useful to perform How To: Install a SQL Data Sync (Preview) Client Agent  and How To: Register a SQL Server Database with a Client Agent procedures. As the tool is in preview stages, it is compulsory to review the Known SQL Data Sync (Preview) Limits and in case of deployment within your data platform look for Plan for Optimization and Understand and Avoid Synchronization Loops  processes. Finally the SQL Data Sync (Preview) Best Practices is good enough to review the referred practices.

The brief architecture about SDS is referred below (source):

So I recommend to check back here about more updates on SDS tool which will be offered as fully operated service in the near future. Before closing the blog post I would like to  refer Recent SQL Data Sync and brief SQL Data Sync Overview  videos.