Databases Reference
In-Depth Information
Figure 7-6.
Adding the hub
In the Add Database to Sync Group dialog, enter the server name, database name, and credentials for the hub
database, and then click Add. For this example, you should use the AdventureWorks2012 database.
Notice now that the icon in the sync group now displays the database name and server name. It also contains two
vital pieces of information. First, it says “Not Deployed.” This means that even though we have marked this database
as the hub, we actually haven't provisioned the database for synchronization.
Second, the icon shows a small, green circle, indicating that the Data Sync service can successfully connect to
and communicate with the SQL Database instance.
■
the icon will display a red X if it cannot communicate with the SQL Database instance. If this is the case, you
should either look at the Firewall rules to ensure that a rule has been added for your Ip address, or check the credentials
to ensure they were entered correctly.
Note
The next step is to provision the member databases. We'll first provision the SQL Database member by clicking
the icon labeled “Click to add a Windows Azure SQL Database.” Again, pretty obvious. This brings up a dialog similar
to the one for the hub. Enter the server name, database name, and credentials for the member database.
This dialog, however, contains an additional configuration for setting the Sync Direction. Sync Direction simply
specifies which direction the data is being synchronized. There are three options:
•
Bi-Directional:
Data is synchronized in both directions between hub and member.
•
Sync to the Hub:
Data is synchronized from the member to the hub only.
•
Sync from the Hub:
Data is synchronized to the member from the hub only.
