Known SQL Data Sync (Preview) Limits
Updated: February 12, 2014
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 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.
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:
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.
Maximum number of sync groups any database can belong to.
Maximum number of endpoints in a single sync group
Maximum number of on-premises endpoints in a single sync group.
Filters per table
Due to SQL Server constraints and SQL Data Sync (Preview) overhead the number of column filters is limited.
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
Database, table, schema, and column names
50 character per name
Tables in a sync group
Columns in a table in a sync group
Data row size on a table
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.
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.
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.
ConceptsSQL Data Sync
SQL Data Sync (Preview) Community Resources
SQL Database Data Types supported by SQL Data Sync (Preview)
Conflict Resolution when Synchronizing
Data Security in SQL Data Sync (Preview)
SQL Data Sync (Preview)Troubleshooting Guide
Glossary of SQL Data Sync Terms
Other ResourcesKnown SQL Data Sync Issues
Azure Management Portal
SQL Azure Data Sync [Channel 9 videos]
SQL Data Sync Forum