Database Reference
In-Depth Information
Synchronizing Endpoint plqfubbqom.database.windows.net,TechBio2 ==> HUB. Conflict
Endpoint wins
Total Changes Transferred = 1, Total Changes Failed = 0.
Sync time (in seconds): 1.8.
Synchronizing HUB ==> Endpoint plqfubbqom.database.windows.net,
TechBio2. Conflict HUB wins
Total Changes Transfered = 0, Total Changes Failed = 0.
Sync time (in seconds): 1.7.
Looking back at Figure 11-16, you see that the
UPDATE
statement generated two “1 row(s) affected”
updates. Where did the second update come from? It came from the trigger on the base table. When you
updated the Users table, the Users_tracking table was also updated such that when a data sync takes
place, the data sync knows there is a change on the member side.
Scheduling Data Synchronization
Let's talk about scheduling a data sync. Go to the SQL Azure Data Sync home page, select your sync
group, and then click the Schedule Sync link. A schedule recurrence pattern is displayed, giving you the
option to choose the frequency of the sync recurrence: None, Hourly, Daily, Weekly, and Monthly. If
None is selected, data synchronization occurs manually. Select any of the other options to display
additional options for running the data sync. For example, in Figure 11-17, the Weekly option is selected,
and additional options are displayed that let you select days of the week and what time to run the data
synchronization.
Figure 11-17.
Scheduling a data sync
Defining a schedule for a data sync doesn't display the schedule on the Sync Group list page, but
rest assured that the scheduled is indeed saved and runs when scheduled. Let's wrap up this chapter
with a discussion of synching on-premises and SQL Azure databases.
Synching an On-Premises Database with SQL Azure
You read earlier that the SQL Azure Data Sync Service only works between SQL Azure databases.
However, Microsoft has released a Community Technology Preview (CTP) of a tool called Microsoft Sync
Framework Power Pack for SQL Azure. This tool lets you synchronize your local database with an Azure
database.
You can download the Power Pack by going to
www.microsoft.com/downloads
and searching for
“Sync Framework Power Pack”. The download page includes a Microsoft Word document that walks you
through the Power Pack's features, functionality, and components. Download the Power Pack and also
that Word file with the documentation. Be sure to read the documentation!
