data migration and data-tier applications with sql azure
DESCRIPTION
SQL Saturday Philadelphia March 5, 2011, Migrating SQL Server database applications to SQL Azure with data migration and data-tier applications.TRANSCRIPT
![Page 1: Data Migration and Data-Tier Applications with SQL Azure](https://reader034.vdocuments.us/reader034/viewer/2022042515/54b5a9714a7959400b8b45a9/html5/thumbnails/1.jpg)
Migrate SQL Server Apps to SQL Azure Cloud DB
Mark Kromer, MicrosoftJoe D’Antoni, Synthes
![Page 2: Data Migration and Data-Tier Applications with SQL Azure](https://reader034.vdocuments.us/reader034/viewer/2022042515/54b5a9714a7959400b8b45a9/html5/thumbnails/2.jpg)
Session Objectives and Takeaways
Objectives:Overview of SQL Azure Cloud DBMigrate application databases to AzureDemonstrate database migration from SQL Server to CloudApplication Database Deployment with Data-Tier Application
![Page 3: Data Migration and Data-Tier Applications with SQL Azure](https://reader034.vdocuments.us/reader034/viewer/2022042515/54b5a9714a7959400b8b45a9/html5/thumbnails/3.jpg)
SQL Azure DatabaseThe first and only true relational database as a service
Elastic Scale Developer Agility
Self-managed
• Database utility; pay as you grow
• Flexible load balancing• Business-ready SLAs• Enable multi-tenant
solutions• World-wide presence
• Easy provisioning and deployment
• Auto high-availability and fault tolerance
• Self-maintaining infrastructure; self-healing
• No need for server or VM administration
• Build cloud-based database solutions on consistent relational model
• Leverage existing skills through existing ecosystem of developer and management tools
• Explore new data application patterns
![Page 4: Data Migration and Data-Tier Applications with SQL Azure](https://reader034.vdocuments.us/reader034/viewer/2022042515/54b5a9714a7959400b8b45a9/html5/thumbnails/4.jpg)
SQL Azure Database
Based on SQL Server 2008 R2 engineUse same tools and data access frameworksSix global datacentersHigh Availability & Redundancy
Reads are completed at the primaryWrites are replicated to a quorum of secondaries
Replica 1
Replica 2
Replica 3
DB
Single LogicalDatabase
Multiple PhysicalReplicas
Single Primary
MultipleSecondaries
![Page 5: Data Migration and Data-Tier Applications with SQL Azure](https://reader034.vdocuments.us/reader034/viewer/2022042515/54b5a9714a7959400b8b45a9/html5/thumbnails/5.jpg)
Application TopologiesSQL Azure access fromwithin MS Datacenter
(Azure compute)
SQL Azure Access from outside MS Datacenter(On-premises)
SQL Azure Access from within and outside MS Datacenter
(On-premises & Azure Compute)
Application/ Browser
SOAP/RESTHTTP/S
Astoria/REST - EDMHTTP/S
App Code
(ASP.NET)
App Code(ASP.NET)
T-SQL (TDS)
SQL Azure WindowsAzure
Code Near
App code/ Tools
T-S
QL (
TD
S)
SQL Azure
Code Far Hybrid
SQ
L A
zure
Data
Syn
cWindows
Azure
SQL Azure
SQL Serve
rApp code/ Tools
App Code
(ASP.NET)
App Code(ASP.NET)
T-SQL (TDS)
![Page 6: Data Migration and Data-Tier Applications with SQL Azure](https://reader034.vdocuments.us/reader034/viewer/2022042515/54b5a9714a7959400b8b45a9/html5/thumbnails/6.jpg)
demo
SQL Azure Database Management
![Page 7: Data Migration and Data-Tier Applications with SQL Azure](https://reader034.vdocuments.us/reader034/viewer/2022042515/54b5a9714a7959400b8b45a9/html5/thumbnails/7.jpg)
demo
Application Migration from On-Premises SQL Server to SQL Azure in the Cloud
![Page 8: Data Migration and Data-Tier Applications with SQL Azure](https://reader034.vdocuments.us/reader034/viewer/2022042515/54b5a9714a7959400b8b45a9/html5/thumbnails/8.jpg)
demo
Database Migration from SQL Server to SQL Azure
![Page 9: Data Migration and Data-Tier Applications with SQL Azure](https://reader034.vdocuments.us/reader034/viewer/2022042515/54b5a9714a7959400b8b45a9/html5/thumbnails/9.jpg)
Introducing SQL Azure Data Sync”Synchronization of SQL Server and SQL Azure Databases”
On-Premises (Headquarters)
Syn
c
Sync
Remote OfficesSQL Azure Data SyncRetail Stores
Sync Sync
Sync
SQL Azure Database
Sync Sync CTP1
(N
ow
)
CTP2
![Page 10: Data Migration and Data-Tier Applications with SQL Azure](https://reader034.vdocuments.us/reader034/viewer/2022042515/54b5a9714a7959400b8b45a9/html5/thumbnails/10.jpg)
On-Premises to Cloud Symmetry
SQL Server to SQL Azure Sync
Sync
Benefits• Makes cloud extension
rather than replacement
• Enables moving workload to cloud in stages preserving investment in existing infrastructure
• New scenarios spanning enterprise, cloud
SQL Azure
![Page 11: Data Migration and Data-Tier Applications with SQL Azure](https://reader034.vdocuments.us/reader034/viewer/2022042515/54b5a9714a7959400b8b45a9/html5/thumbnails/11.jpg)
SQL Azure to SQL Azure Synchronization
Benefits• Geo-
synchronization of data across data centers
• Scale-out read or read/write
![Page 12: Data Migration and Data-Tier Applications with SQL Azure](https://reader034.vdocuments.us/reader034/viewer/2022042515/54b5a9714a7959400b8b45a9/html5/thumbnails/12.jpg)
Extending Data to Retail and Remote Offices
SQL Azure to SQL Server Sync
Benefits• Share data with remote and
retail offices, bringing data closer to the end-users
• Lower latency – data access doesn’t require round trips
• Higher availability – app still runs if server is unreachable
• Reduced network utilization – most data access is local
SQL Azure
![Page 13: Data Migration and Data-Tier Applications with SQL Azure](https://reader034.vdocuments.us/reader034/viewer/2022042515/54b5a9714a7959400b8b45a9/html5/thumbnails/13.jpg)
Sync End to End Scenarios
On-Premises Applications
Sync
SyncSync
Offline Applications
Sync
SyncSQL Azure Database
Sync Sync
Sync
SQL Azure Data Synchttp://azure.com
SQL Azure Data Sync CTP2(Coming in near future)
Microsoft Sync Framework 4.0 CTP available now!
Sync Sync
Retail & Remote Offices
SQL Azure Data Sync CTP1(Available now from http://azure.com)
![Page 14: Data Migration and Data-Tier Applications with SQL Azure](https://reader034.vdocuments.us/reader034/viewer/2022042515/54b5a9714a7959400b8b45a9/html5/thumbnails/14.jpg)
Data Tier Applications
New feature in SQL Server 2008 R2 Allows developers to own the database
schema and definitions Still needs work (more to come) Microsoft seems to have invested
deeply to build this, so it will get better (hopefully)
Interacts with SQL Azure—this is one method of deploying application code there
Data-Tier Application Project(Departmental apps in V1)
Visual Studio
SQL Azure
Build
.dacpac
Deploy
![Page 15: Data Migration and Data-Tier Applications with SQL Azure](https://reader034.vdocuments.us/reader034/viewer/2022042515/54b5a9714a7959400b8b45a9/html5/thumbnails/15.jpg)
Software Requirements
![Page 16: Data Migration and Data-Tier Applications with SQL Azure](https://reader034.vdocuments.us/reader034/viewer/2022042515/54b5a9714a7959400b8b45a9/html5/thumbnails/16.jpg)
What’s in a DACPAC?
![Page 17: Data Migration and Data-Tier Applications with SQL Azure](https://reader034.vdocuments.us/reader034/viewer/2022042515/54b5a9714a7959400b8b45a9/html5/thumbnails/17.jpg)
demo
Application Deployment to SQL Azure using Data Tier Applications
![Page 18: Data Migration and Data-Tier Applications with SQL Azure](https://reader034.vdocuments.us/reader034/viewer/2022042515/54b5a9714a7959400b8b45a9/html5/thumbnails/18.jpg)
Thank you!
Mark Kromer, Microsofthttp://www.sqlmag.com/blogs/sql-server-bi.aspxhttp://mssqldude.wordpress.comhttp://twitter.com/mssqldude
Joe D’Antoni, SynthesPhiladelphia SQL Server User Group VPhttp://joedantoni.wordpress.comhttp://twitter.com/jdanton