Plan for Optimization
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 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.
Reduce Your Costs
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 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.
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 (Preview)
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)
Known SQL Data Sync (Preview) Issues
SQL Data Sync (Preview)Troubleshooting Guide
Glossary of SQL Data Sync Terms
Other ResourcesWindows Azure Management Portal
SQL Azure Data Sync [Channel 9 videos]
SQL Data Sync Forum