SALES: 1-800-867-1380

Create your Sync Group (SDS)

Updated: October 31, 2013

 

SQL Azure Data Sync Icon

A sync group is a logical grouping of SQL Database instances and optional SQL Server databases. This grouping defines which databases, tables and columns are synchronized together. This topic walks you through the create-a-sync-group wizard that is part of the Azure Management portal.

The Microsoft Azure SQL Data Sync plug-in on the Microsoft Azure Silverlight portal has been decommissioned. Going forward, use the Microsoft Azure Management portal, for Azure SQL Data Sync.

You access SQL Data Sync (Preview) via the SYNC tab under SQL Database at the Microsoft 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.

See the Navigation section below for links to topics you should read before you start and guidance on creating and modifying sync groups.

<< PreviousNext >>

This section walks you through the steps to create a sync group. If the sync group includes an instance of a SQL Server database, follow the directions at Install a SQL Data Sync (Preview) Client Agent. After the Client Agent is installed, follow the directions at Register a SQL Server Database with a Client Agent. You must register each SQL Server databases you want included in the sync group.

Whenever possible, a sync group should have only one database that contains data prior to the first synchronization. If more than one database contains data, then the first time the group is synchronized, every row is treated as a data conflict (even if the data is identical). Conflict resolutions can, depending on the database size, cause the initial synchronization to take days, weeks, or in some cases, months.

If the databases are in different data centers, the cost of your initial synchronization will be higher than necessary. The additional round trips required to resolve each conflict result in unnecessary ingress and egress.

The client agent and the sync group must be in the same data center. SQL Server databases registered with the agent can be in any data center.

  1. Navigate your browser to the Azure Management Portal and sign in.

  2. After the portal finishes loading, click SQL DATABASES in the left pane.

  3. Click ADD SYNC at the bottom of the screen.

  4. From the drawer, click New Sync Group.

  1. Give the sync group a meaningful name.

  2. From the dropdown, select the data center to host this sync group.

  3. If you have multiple subscriptions, from the dropdown, select the Microsoft Azure subscription to host this sync group.
    If you have just one subscription, SQL Data Sync (Preview) selects that subscription without any action needed on your part.

  4. To continue, click the right-arrow.

The hub database in a sync group must be a Microsoft Azure SQL Database instance. Do not attempt to register the hub database with a SQL Data Sync (Preview) client agent.

  1. From the dropdown, select a SQL Database instance to be the Hub database for this sync group.

  2. Enter the credentials for accessing the Hub database – User Name and Password.

  3. From the dropdown, select the conflict resolution policy for this sync group.
    Once the sync group is deployed, you cannot change the conflict resolution policy.
    For more information on SQL Data Sync (Preview) conflict resolution, see the topic Conflict Resolution when Synchronizing.

  4. To continue, click the right-arrow.

The reference databases in a sync group can be any combination of Microsoft Azure SQL Database instances or a SQL Server databases.

  1. From the dropdown, select the database you want to add to this sync group.
    The databases are grouped by Microsoft Azure subscription and agent.

    noteNote
    A SQL Server database must be registered with an agent to be listed. SQL Database instances should not be registered with an agent.

  2. Enter the credentials for accessing the selected database – User Name and Password.

  3. From the dropdown, select the sync direction for this database.
    Valid sync directions are:

    • Bi-directional – data changes in either this database or the Hub database are written to the other database.

    • To the Hub – data changes in this database are written to the Hub database, but changes in the Hub database are not written to this database.

    • From the Hub – data changes in the Hub database are written to this database, but changes to this database are not written to the Hub.

  4. To finish, click the right-arrow.

When finished, this sync group is listed with any other sync groups you created under the SYNC tab on the SQL Databases portion of the Microsoft Azure Management Portal. The sync group status is Not Ready until you configure and set the sync rules (define the data to sync).

SQL Data Sync (Preview) is a feature of SQL Database. From the Azure Management portal you can perform all tasks necessary to create, deploy, and modify a sync group.

 

Before you start

Before you begin to design and implement your synchronizations, you should be familiar with these topics.

How to create a sync group

There are six steps to creating a sync group from the Azure Management portal. Details on each step can be found by following these links.

  1. Sign in to the Azure SQL Database Management portal
    SQL Data Sync (Preview) is found as a tab under SQL Database only after you create a sync group.

  2. Install a SQL Data Sync (Preview) Client Agent

  3. Register a SQL Server Database with a Client Agent

  4. Create your Sync Group (SDS)

  5. Define your sync data (SDS)

  6. Configure your sync group (SDS)

 

How to modify a sync group

You can modify a sync group’s schema by adding/removing tables or columns in the sync group; or by altering a column’s width or data type. Details can be found by following the links.

See Also

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft