Hade du nytta av den här sidan?
Din feedback om det här innehållet är viktig. Berätta vad du tycker.
Ytterligare feedback?
1500 tecken kvar
Create a Sync Group
Det här innehållet finns inte tillgängligt på ditt språk men här finns den engelska versionen,

Create a Sync Group

Updated: August 25, 2015


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


Create a Sync Group
There are six steps to create a sync group:


Sign in to Azure

Sign in to the Azure SQL Database Management portal.

Install a SQL Data Sync 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

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.

Define your data sync

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

© 2015 Microsoft