Plan for Optimization

Plan for Optimization

Updated: August 28, 2015


SQL Azure Data Sync Icon

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.

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

  3. Register a SQL Server database with a Client Agent

  4. Create your sync group

  5. Define your data sync

  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

© 2015 Microsoft