SYNCHRONIZING DATA WITH SQL AZURE USING SQL AZURE

SYNCHRONIZING DATA WITH SQL AZURE USING SQL AZURE DATA SYNC Mark Scurrell Lead Program Manager This document has been prepared for limited distribution within Microsoft. This document contains materials and information that Microsoft considers confidential, proprietary, and significant for the protection of its business. The distribution of this document is limited to those solely involved with the program described within. Confidential and Proprietary © 2011 Microsoft Last Updated:

SYNCING BETWEEN SQL SERVER AND SQL AZURE Cloud On-Premises Application • Hybrid applications • One-way sync to cloud • One-way sync from cloud • Two-way sync SQL Server Sy nc • Multiple locations (e. g. branch office, retail offices) • Share data between locations • Aggregate data in cloud SQL Azure nc Sy Application SQL Server Application

DEMO

SYNCING BETWEEN SQL AZURE DATABASES Cloud Application SQL Azure Application nc Sy • Geographically located web applications • E. g. Use with Windows Azure Traffic Manager Sync SQL Azure • Scale-out via multiple copies of data • E. g. Separate reporting & OLTP workloads; multiple Web sites Sy n c Application SQL Azure

DEMO

SYNCING BETWEEN SQL AZURE DATABASES Cloud On-Premises Application • Hybrid applications • One-way sync to cloud • One-way sync from cloud • Two-way sync SQL Server Sy nc Application SQL Azure Application nc Sy • Geographically located web applications • E. g. Use with Windows Azure Traffic Manager Sync • Multiple locations (e. g. branch office, retail offices) • Share data between locations • Aggregate data in cloud SQL Azure c yn S Application SQL Azure • Scale-out via multiple copies of data • E. g. Separate reporting & OLTP workloads; multiple Web sites Sy n c Application SQL Azure SQL Server

FURTHER. FORWARD. FASTER. • Learn more Visit the Microsoft Virtual Academy Free technical SQL Server training courses • Get more Download SQL Server 2012 Trial Software 180 -day evaluation of SQL Server 2012 • Do more Participate in virtual launch activities and collect points for prizes The more points you earn, the bigger your prize could be

© 2011 Microsoft Corporation. All rights reserved. Microsoft, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U. S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.