Plan for Optimization
Updated: December 2, 2014
Welcome to SQL Data Sync (Preview). This topic is the third 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.
You can reduce your costs by minimizing the data traffic leaving or entering a data center. The cost of moving data between data centers is greater than moving data within a data center.
Locate your SQL Data Sync (Preview) server in the data center where you have the most data traffic.
Locate your sync group hub in the data center to where you have the most data traffic.
Synchronize only as often as is required by your business needs.
This means some sync groups will synchronize often and others less frequently. For example, it is unlikely that you need your Payroll sync group to synchronize every five minutes. A weekly or monthly sync would likely be sufficient.
Some of the same issues that impact your costs also impact the efficiency of your sync groups.
It is both cheaper and faster to keep as much of your data movements within a data center as you can. Throughput within a data center is about double what it is between data centers.
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 Database Data Types supported by SQL Data Sync
Conflict Resolution when Synchronizing
Data Security in SQL Data Sync
SQL Data Sync Troubleshooting Guide
Glossary of SQL Data Sync Terms
Other ResourcesAzure Management Portal
SQL Azure Data Sync [Channel 9 videos]
SQL Data Sync Forum