Export (0) Print
Expand All

Add a Database to your Sync Group (SDS)

Updated: February 12, 2014

 

SQL Azure Data Sync Icon

Over time, you may want to modify a SQL Data Sync (Preview) sync group. This topic walks you through adding a SQL Server or a SQL Data Sync (Preview) to an existing sync group.

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.

Modifications you can make to a sync group include:

Whenever possible, when you add a database to an existing sync group, it should be empty. If the database contains data, then the first time it is synchronized with the sync group, every row in the database 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 known cases, months.

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

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

  3. Click the SYNC tab.

  4. From the list of sync groups, click the sync group you want to add a database to.

  5. At the bottom of the page, click ADD.

  1. From the dropdown, select the database you want to add to this sync group.
    The databases are grouped by subscription and agent. Note: a SQL Server databases must have been registered with an agent to be listed.

  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:

    • Di-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 database is listed with the other databases in this sync group.

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)

See Also

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