Database Reference
In-Depth Information
Figure 11-12.
Scheduled Sync Jobs list
In this example the synchronization is simple, so by the time you're finished reading this, you can
press F5 to read the page. The Status changes to Completed, as shown in Figure 11-13. If you refresh
quickly enough, you see the status with a value of Processing.
Figure 11-13.
A completed synchronization
One of the great things about the Data Sync page in Figure 11-13 is that below the list of scheduled
sync jobs is the Sync Job Log. By clicking the ViewLog link for a given sync job, you can view the log
information for the selected sync job in the Sync Job Log section. Information from the log provides
great detail pertaining to the synchronization process, including the total changes and how long those
changes took. For example, the following log shows a sync like the one you just executed. It shows that
there were no sync changes from member to hub, that there were a total of 105 total changes from hub
to member, and that the sync took a mere 2 seconds:
Retrieving DbSyncScopeDescription from Hub
Checking to see if Scope 71793881-3437-4861-870a-af5eaebe7197 exists in endpoint
plqfubbqom.database.windows.net,TechBio2
Scope doesnt exist. Provisioning server.
Synchronizing Endpoint plqfubbqom.database.windows.net,TechBio2 ==> HUB.
Conflict Endpointwins
Total Changes Transferred = 0, Total Changes Failed = 0.
Sync time (in seconds): 2.4.
Synchronizing HUB ==> Endpoint plqfubbqom.database.windows.net,TechBio2.
Conflict HUB wins
Total Changes Transfered = 105, Total Changes Failed = 0.
Sync time (in seconds): 2.0.
Looking at the Database Changes
Earlier, this chapter mentioned that the SQL Azure Data Sync Service makes changes to the databases, so
let's look at those. Back in SQL Server Management Studio, expand the Tables nodes of both the TechBio
database and the TechBio2 database. Notice that the SQL Azure Data Sync created four new tables in
both databases, and it also created the Users table in the TechBio2 database, shown in Figure 11-14.
