Eksportér (0) Udskriv
Udvid alt
Dette indhold er ikke tilgængeligt på dit sprog, men her er den engelske version.

Define your sync data (SDS)

Updated: October 31, 2013

[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

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 defining the databases and tables that belong to this sync group.

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.

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

<< PreviousNext >>

How To: Define your Sync Data

The sync rules define which databases, tables, and columns are synchronized.
If you wish to use filters to sync a subset of rows in a column use the Silverlight UI at <LINK>.

Navigate to the sync rules screen

  1. Navigate your browser to the Windows Azure Management Portal.

  2. Click SQL DATABASES in the left pane.

  3. Click the SYNC tab.

  4. From the list of sync groups, click the name of the sync group for which you want to define the sync rules.

  5. Click SYNC RULES.

Select the tables and columns to sync

  1. From the list of databases, click the name of the database whose schema you want to use for the sync group.

  2. For each table in the database, select the columns you want included in the synchronization.
    Columns of unsupported data types are disabled and cannot be selected.
    NOTE: You can perform group selections (all columns from a table or all columns from all tables) by clicking SELECT at the bottom of the screen.

  3. When finished selecting tables and columns, click REFRESH SCHEMA.
    SQL Data Sync (Preview) automatically generates the sync group schema based upon the tables and columns you selected. See the topic How To: Update a Sync Group Schema (SDS) for guidance on how to alter an existing SQL Data Sync (Preview) schema.

  4. Wait until the schema finishes refreshing.


SQL Data Sync (Preview) is a feature of SQL Database. From the Windows 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 Windows Azure Management portal. Details on each step can be found by following these links.

  1. Sign in to the Windows 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


© 2014 Microsoft