Export (0) Print
Expand All
1 out of 1 rated this helpful - Rate this topic

System Requirements for SQL Data Sync (Preview)

Updated: October 31, 2013

[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]

 

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 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.

System Requirements

Because SQL Data Sync (Preview) is a feature of the Windows Azure SQL Database cloude 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 2008 R2 you can download a free trial from SQL Server 2012 trial or a trial of SQL Server 2008 R2.
    SQL Data Sync (Preview) currently supports only SQL Server and SQL Database. Express versions of SQL Server are not supported.

  • A Windows Azure account and subscription.
    You can sign up for an account at https://windows.azure.com.

  • 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 2008, Windows Vista, or Windows 7 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.

Navigation

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.

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

  3. Register a SQL Server Database with a Client Agent

  4. Create your Sync Group (SDS)

  5. Define your sync data (SDS)

  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

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.