System Requirements for SQL Data Sync

System Requirements for SQL Data Sync

Updated: August 28, 2015


SQL Azure Data Sync Icon

Welcome to SQL Data Sync (Preview). This topic is the first 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.

Because SQL Data Sync (Preview) is a feature of the Microsoft Azure SQL Database cloud service there are no bits for you to install on your computer beyond one of the versions of SQL Server and Windows listed in the minimum requirements below. There are .NET and subscription requirements as outlined below.

Minimum requirements for using SQL Data Sync (Preview)

  • SQL Server 2005 SP2.
    SQL Data Sync (Preview) works best with SQL Server 2008 R2 and later as support for SQL Database was added to SQL Server Management Studio in SQL Server 2008 R2. If you do not have SQL Server you can download a free trial from SQL Server Evaluations.
    SQL Data Sync (Preview) currently supports only SQL Server and SQL Database. Express versions of SQL Server are not supported.

  • A Microsoft Azure account and subscription.

  • A SQL Database subscription.
    You need at least one SQL Database subscription. If you need to host SQL Database instances in multiple data centers you need a SQL Database subscription for each data center.

  • Windows Server 2008 or later or Windows Vista or later operating systems.

  • An x86 or x64 computer.

The following are additional requirements if you include a SQL Server database in any of your sync groups.

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