Transcript Synchronizing Data With SQL Azure Using SQL

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: Tuesday, July 21, 2015
SYNCING BETWEEN SQL SERVER AND SQL AZURE
On-Premises
Application
Cloud
• Hybrid applications
• One-way sync to cloud
• One-way sync from cloud
• Two-way sync
SQL
Server
• Multiple locations (e.g. branch office,
retail offices)
• Share data between locations
• Aggregate data in cloud
Application
SQL
Server
SQL
Azure
DEMO
SYNCING BETWEEN SQL AZURE DATABASES
Cloud
• Geographically located web
applications
• E.g. Use with Windows
Azure Traffic Manager
• Scale-out via multiple copies of
data
• E.g. Separate reporting & OLTP
workloads; multiple Web sites
DEMO
SYNCING BETWEEN SQL AZURE DATABASES
On-Premises
Application
Cloud
• Hybrid applications
• One-way sync to cloud
• One-way sync from cloud
• Two-way sync
SQL
Server
• Multiple locations (e.g. branch office,
retail offices)
• Share data between locations
• Aggregate data in cloud
Application
SQL
Server
• Geographically located web
applications
• E.g. Use with Windows
Azure Traffic Manager
• Scale-out via multiple copies of
data
• E.g. Separate reporting & OLTP
workloads; multiple Web sites
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, 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.