Databases Reference
In-Depth Information
The basic idea and concept behind this architecture is the following:
•
Data Sync is built on the Windows Azure public platform.
•
You can configure a sync group and perform a sync quickly and easily on the Windows Azure
Platform.
As with SQL Reporting, SQL Data Sync management is not yet available in the new Preview portal, so this chapter
will illustrate using SQL Data Sync in the existing Silverlight portal.
Configuring Synchronization
Now that you're familiar with the foundation of how the Data Sync service works, let's dive in and configure a new
sync for SQL Data Sync, in order to sync two databases. This example synchronizes the same AdventureWorks
database for Windows Azure SQL Database used in Chapter 6. You can find this database and instructions for
installing it here:
This database will be the hub database. Additionally, this example will utilize two member databases; one
located on-premises and another SQL Database. My second SQL Database will be located in a second region to
illustrate regional synchronization, but if you are walking through this example feel free to put the second SQL
Database in the same region.
Provision a SQL Data Sync Server
Log in to the portal with your LiveID at
https://windows.azure.com
.
The first task is to provision a Data Sync server.
The Navigation pane is broken into two sections. The lower section contains the components and services available in
the Management Portal. The top section shows either a list of available subscriptions linked to your LiveID, or helpful
links to get started as shown in Figure
7-3
.
