Using SQL Azure Data Sync Service to provide Geo-Replication of SQL Azure databases
- Posted: Jul 16, 2010 at 11:19 AM
- 9,435 Views
- 3 Comments
Download
How do I download the videos?
- To download, right click the file type you would like and pick “Save target as…” or “Save link as…”
Why should I download videos from Channel9?
- It's an easy way to save the videos you like locally.
- You can save the videos in order to watch them offline.
- If all you want is to hear the audio, you can download the MP3!
Which version should I choose?
- If you want to view the video on your PC, Xbox or Media Center, download the High Quality WMV file (this is the highest quality version we have available).
- If you'd like a lower bitrate version, to reduce the download time or cost, then choose the Medium Quality WMV file.
- If you have a Zune, WP7, iPhone, iPad, or iPod device, choose the low or medium MP4 file.
- If you just want to hear the audio of the video, choose the MP3 file.
Right click “Save as…”
- High Quality WMV (PC, Xbox, MCE)
- MP3 (Audio only)
- Mid Quality WMV (Lo-band, Mobile)
- High Quality MP4 (iPad, PC)
- MP4 (iPod, Zune HD)
In this second of a 3 part webcast series, I introduce you to the Data Sync Service for SQL Azure. This service extends on the SQL Azure Data Sync tools’ ability to provide symmetry between SQL Server and SQL Azure where data changes at either location
are bi-directionally synchronized between on-premises and the cloud. With SQL Azure Data Sync Service, we have extended that capability to allow you to easily geo-distribute that data to one or more SQL Azure data centers around the world. Now, no matter
where you make changes to your data, it will be seamlessly synchronized to all of your databases whether that be on-premises or in any of the SQL Azure data centers. To learn more and register for access to SQL Azure Data Sync Service please visit:
http://sqlazurelabs.com/.
Comments Closed
Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation,
please create a new thread in our Forums,
or
Contact Us and let us know.
Follow the Discussion
Nice video, thanks! But what about conflict management. What if someone in europe changes the same customer as in the US? How do you handle this?
Can you also synchronize to mobile devices? And what about filtering? For example: I only want to send VIP customers to europe. Is this possible?
Thanks,
Bas
Yes, SQL Azure Data Sync does support conflict handling and automatically resolves any conflicts for you. As for filtering the only level of filtering currently available is at a table level (meaning you can choose to sync only specific tables). Over time we will add more filtering down to the level of rows and columns.
Liam
Liam, awesome demo, thanks!
>Yes, SQL Azure Data Sync does support conflict handling and automatically resolves any conflicts for you
Do you have the rules on how conflicts are handled listed anywhere? Here's an example -
- Suppose three databases in a sync group: NorthCentral US (HUB), Europe (Member), and Southeast Asia (Member).
Here are some scenarios -
Emmanuel
Remove this comment
Remove this thread
close