Export (0) Print
Expand All
1 out of 1 rated this helpful - Rate this topic

Create a Sync Group (SDS)

Updated: February 12, 2014

[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]

 

SQL Azure Data Sync Icon

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

 

Topic Description

Install a SQL Data Sync (Preview) Client Agent

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.

Register a SQL Server Database with 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.

Create your Sync Group (SDS)

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 your sync data (SDS)

Define the databases, tables, and columns to be synchronized by this sync group.

Configure your sync group (SDS)

Set the sync frequency and connection details for the databases in the sync group.

See Also

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.