pushing data to and from the cloud with sql azure data sync
DESCRIPTION
Microsoft SQL Azure Data Sync is a cloud-based data synchronization service built on the Microsoft Sync Framework technologies. It provides bi-directional data synchronization and data management capabilities allowing data to be easily shared across SQL Azure databases across multiple data centers. In this talk Microsoft MVP Chris Woodruff will demonstrate and explain how to set up SQL Azure Data Sync and great tips to have the best experience when synchronizing your data.TRANSCRIPT
SQL Azure Data SyncPushing Data to and from the Cloud with
SQL Azure Data Sync
Chris WoodruffMicrosoft Cloud Practice Lead
Level: Intermediate
Who am I?
Chris WoodruffMVP, Visual C#Telerik, Inc.
[email protected]://chriswoodruff.comhttp://deepfriedbytes.comtwitter @cwoodruff
Talk Goals
• Overview of SQL Azure Data Sync• Understand Benefits of SQL Azure Data
Sync• Demo SQL Azure Data Sync• Demo Syncing Data through Microsoft
Sync Framework• Scenarios
Microsoft Sync Framework
• Microsoft Sync Framework is a comprehensive synchronization platform enabling collaboration and offline for applications, services and devices. Developers can build synchronization ecosystems that integrate any application, any data from any store using any protocol over any network.
benefit from SQL Azure Data Sync
• Create varied and complex synchronizations without the necessity of writing a lot of code.
• Leverage the Microsoft Windows Azure platform and Microsoft SQL Azure without the necessity of creating and managing your own cloud.
DemoDemo SQL Azure Data Sync through Azure
Management Portal
DemoDemo Syncing Data through Microsoft Sync
Framework
What happens when things go very wrong?
If there is a conflict between the on-premise database and the SQL Azure database, the ApplyChangeFailed event will be raised.
The DbApplyChangeFailedEventArgs object provides information about the error or conflict that caused the failure
What are the differences between SQL Azure Data Sync and Custom Data Sync with SQL Azure?
Scenarios for SQL AzureData Backup to Cloud
On-PremiseDatabase
Azure SQLDatabase
SCENARIOS FOR SQL AZURE
Mobile Data Syncing
On-PremiseDatabase
Azure SQLDatabase
SCENARIOS FOR SQL AZURE
Cloud Data Syncing
Questions?