Create a Sync Group (SDS)
Updated: February 12, 2014
SQL Data Sync (Preview) enables you to synchronize your data across on-premises and SQL Database instances. To synchronize your data across multiple databases you need to create a Sync Group. A sync group logically groups together two or more SQL Server or SQL Database instances. The topics in this section cover how to create, update and delete sync groups.
A Sync Group may be comprised of one or more SQL Database instances and zero or more SQL Server databases.
When you create a sync group, be sure that only one of the databases contains data prior to the first synchronization. If multiple databases contain data, each common row is treated as a data conflict, even if the data is identical. Data conflicts significantly slow down a synchronization. Depending on the size of your database, if multiple databases are populated with data, the first synchronization can take days or weeks. Conflict resolution also requires multiple round trips between the databases. If your databases are in different data centers, these round trips can add significantly to your ingress and egress charges.
Before you begin to design and implement your synchronizations, you should be familiar with these topics.
The Windows Azure SQL Data Sync plug-in on the Windows Azure Silverlight portal has been decommissioned. Going forward, use the Windows Azure Management portal, for Windows Azure SQL Data Sync.
You access SQL Data Sync (Preview) via the SYNC tab under SQL Database at the Windows Azure Management portal. The SYNC tab is only available when you have one or more sync groups. See the topic How To: Create a Sync Group (SDS) for guidance on creating and modifying a sync group from this portal.
In This Section
In order for you to include SQL Server databases in a sync group, you need an installed client agent. The client agent handles encrypted communications between the sync service and your on-premises SQL Server databases. This topic walks you through the steps to install a client agent.
Every on-premises database must be registered with an installed client agent before it can be added to a sync group. This topic walks you through the steps to register a SQL Server database with an installed client agent.
Walk through the wizard to create a sync group. After the sync group is created you can add other databases to it – see Add a Database to your Sync Group (SDS).
Define the databases, tables, and columns to be synchronized by this sync group.
Set the sync frequency and connection details for the databases in the sync group.
ConceptsSQL Data Sync (Preview)
SQL Data Sync (Preview) Community Resources
SQL Database Data Types supported by SQL Data Sync (Preview)
Data Security in SQL Data Sync (Preview)
Conflict Resolution when Synchronizing
Known SQL Data Sync (Preview) Issues
SQL Data Sync (Preview)Troubleshooting Guide
Glossary of SQL Data Sync Terms
Other ResourcesWindows Azure Management Portal
SQL Azure Data Sync [Channel 9 videos]
SQL Data Sync Forum