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

Known SQL Data Sync (Preview) Limits

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

Welcome to SQL Data Sync (Preview). This topic is the second of five topics you should be familiar with before you design and implement a data synchronization plan. The five preparatory topics are:

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.

SQL Data Sync Limits

Limits per SQL Data Sync server

A: SQL Data Sync (Preview) Preview has the following limits per SQL Data Sync (Preview) Server:

 

Instance Maximum

Maximum number of SQL Data Sync (Preview) servers per subscription.

You may create a SQL Data Sync (Preview) server in each data center listed in the Region drop down as you provision SQL Data Sync (Preview) servers.
See step 6 at Steps to provision a Sync Server.

Maximum number of sync groups any database can belong to.

5

Maximum number of endpoints in a single sync group

30

noteNote
There may be up to 30 endpoints in a single sync group if there is only one sync group. If there is more than one sync group the total number of endpoints across all sync groups cannot exceed 30.

noteNote
If a database belongs to multiple sync groups it is counted as multiple endpoints, not one.

Maximum number of on-premises endpoints in a single sync group.

5

Filters per table

Due to SQL Server constraints and SQL Data Sync (Preview) overhead the number of column filters is limited.

  • Up to 12 column filters per table.

  • An optional 13th column filter if it is on the primary key column.

WarningWarning
The SQL Data Sync (Preview) Preview UI permits any number of columns filters. Exceeding the above limits results in a provisioning failure when you deploy the sync group.

Characters that cannot be used in object names

The names of objects (databases, tables, columns) cannot contain the printable characters period (.), left square bracket ([) or right square bracket (]).

Supported limits on database dimensions

 

Dimension Limit

Database, table, schema, and column names

50 character per name

Tables in a sync group

100

Columns in a table in a sync group

1000

Data row size on a table

24Mb

Navigation

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.

 

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

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.