This article covers the most frequently asked questions regarding SQL Data Sync. If you have a question that is not covered here please ask it in the forum and we will add the most frequently asked questions to this topic.
A: The latest version of SQL Data Sync is the Preview version - SQL Data Sync Preview.
The new capabilities and features for the Preview release include:
We recently released a minor upgrade to the Preview Data Sync Agent. You can download the upgraded Agent from the Download Center.
A: SQL Data Sync supports the following:
SQL Server 2005 SP2 and later versions.
It 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 don't have SQL Server 2008 R2 you can download a free trial from
SQL Server 2008 R2 trial.
Windows 2008, Windows Vista, and Windows 7 operating systems.
An x86 or x64 computer.
A: Not for long.
The CTP2 website will be retired and unavailable a few weeks after the introduction of the Preview version. See the topic SQL Data Sync How to Upgrade for direction on how to upgrade to the Preview version.
A: Yes. Your must have a SQL Database account to host the
Sync Group's Hub database.
Please visit http://www.microsoft.com/windowsazure/sqlazure/ and sign up.
A: During the CTPs there is no charge for the Data Sync Service, however you will still accrue data transfer charges for data moving in and out of your SQL Database. For more details
on this pricing please visit:
http://www.microsoft.com/windowsazure/pricing/. It is possible that with the release of SQL Data Sync v.1 there will be a charge for the service. Watch this space and the topic SQL Data Sync Cost Considerations for the latest information on pricing.
A: Yes, in order to track incremental data changes SQL Data Sync will add change tracking table for each table that is being synchronized when synchronization is configured. During
this configuration, it will also add triggers to your base tables as well as some stored procedures for gathering and applying changes. It is highly recommended that you test SQL Data Sync on a non-production database to ensure that it does not have an adverse
effect on your existing applications.
A: Currently we have one SQL Data Sync service located in the South Central US Windows Azure data center.
A: You can contact us at the forums (http://go.microsoft.com/fwlink/?linkid=230831) with any questions or comments about
SQL Data Sync.
A: When you set up a synchronization group, the service requests credentials for your SQL Database servers. These credentials are stored in encrypted format within the SQL Data Sync
A: No. SQL Data Sync is currently available only as a Preview and is meant only for product feedback for future releases and should not be used in production environments.
A: A standalone executable is installed with the LocalAgentSetup Msi that you can use to de-provision the SQL Data Sync objects that are created when you add a database or table to
your synchronization service.
A: No. SQL Data Sync does not support versioning so you cannot restore to a specific point in time. See the topics Backing Up
Your Data and Restoring Your Data for additional information.
A: SQL Data Sync permits one Data Sync server per subscription. However, a single Data Sync server can host multiple sync groups that encompass multiple SQL Server and SQL Databases.
A: SQL Data Sync Preview has the following limits:
A: SQL Data Sync Preview does not support dynamic schema changes. The only way to get your new schema into the sync group is to remove the current sync group and create a new one with
the new schema. See the topics SQL Data Sync Remove a Sync Group and
SQL Data Sync Create a Sync Group for additional information.
A: A synchronization loop is akin to an infinite loop. Synchronizations occur repeatedly even if there are no changes in either database. To avoid a synchronization loop ensure that
your sync groups do not overlap - that is, this is no table or row that is referred to in a circular manner within or across multiple sync groups.
A: The "Out-of-Date" status results from the database being offline 45 or more days. See
A Database has an "Out-of-Date" Status in the Troubleshooting Guide for how to bring the database back up to date.
A: SQL Data Sync Preview is not backward compatible with CTP2. See the article
How to Upgrade for complete instructions on how to upgrade from CTP2 to SQL Data Sync Preview.
A: The Data Sync Service communicates with SQL Server databases via the Client Agent. This security feature prevents direct communication with databases behind a firewall. When the
Sync Service communicates with the Agent it does so using encrypted connections and a unique token or “Agent Key”. The SQL Server databases authenticate the Agent using the connection string and Agent Key. This design provides a high level of security for
your data. For more information in SQL Data Sync security measures see the article Data Security.
Does Data Sync work with SQL Express versions?