SQL Azure Data Sync Logo

A synchronization group is two or more databases that are logically grouped together for the purpose of synchronizing specified tables, columns and rows. Every sync group must have as one of its databases a SQL Azure database that serves as the sync group hub.

This article walks you through the initial step to create a sync group - provision a Data Sync server. You may provision only one Data Sync server per Windows Azure subscription. However, a single Data Sync server can host multiple sync groups.

This wiki topic may be obsolete.
This wiki topic is no longer updated by Microsoft. We moved the content to the MSDN Library where we keep it current.
To find the latest version of this topic on MSDN click here.


Before you provision a Data Sync server you need to enable access to the hosting SQL Server by Data Sync by setting the server's firewall rules.
  1. Navigate to the SQL Azure Management Portal.

  2. In the left pane select the subscription and SQL Azure server you want to host this Data Sync server.

  3. If there is no SQL Azure server you need to create one.

    1. Click Database in the left pane.

    2. Click Create in the Server portion of the ribbon.

    3. Select the Region where you want this server located.

    4. Enter the Administrator login and password for this server.

  4. On the firewall rules page ensure that the Allow other Windows Azure services to access this server checkbox is checked then click Add. (Figure 1)

    Figure 1 - Firewall Rules


Provision a Sync Server

You need to provision a Data Sync server to host your sync group. It is to your advantage, both in cost and latency, if you locate your Data Sync server where most of your data traffic is generated.
  1. Navigate to the SQL Azure Management Portal.

  2. After the page finishes loading the add-ins, click Data Sync in the left pane. (Figure 2)

    Figure 2: Click Data Sync    

     Note: Any time you want to return to this screen click Subscriptions in the left pane.
  3. Click the Provision a Data Sync Server button. (Figure 3)    

    Figure 3: Click Provision a Data Sync Server      

  4. Carefully read the Terms of Use. (Figure 4:1)
    If you agree to the Terms of Use check the I agree to the Terms of Use statement above check box. (Figure 4:2)
    Click Next or Cancel. (Figure 4:3)    

    Figure 4: Terms of Use      

  5. From the dropdown select the SQL Azure subscription you want to provision (Figure 5:1) then click Next. (Figure 5:2)

    Figure 5: Select the SQL Azure Subscription to Provision 

  6. From the dropdown select the data center you want to host the Data Sync server (Figure 6:1) then click Finish. (Figure 6:2)

    Figure 6: Select the SQL Azure Region to host your Data Sync server      



This release was provided in order to gather feedback from our customers. Now that you have previewed what the SQL Azure Data Sync team is doing, please let us know what you think of our direction, and tell us about your experiences. You can send us your thoughts in any of the following ways:


See Also