Transcript Document
Migrate SQL Server Apps to SQL Azure Cloud DB Session Objectives and Takeaways • Objectives: –Overview of SQL Azure Cloud DB –Migrate application databases to Azure –Demonstrate database migration from SQL Server to Cloud –Application Database Deployment with Data-Tier Application SQL Azure Database SQL Azure Database Single Logical Database Multiple Physical Replicas Replica 1 DB Replica 2 Replica 3 Application Topologies SQL Azure Access from outside SQL Azure access from within MS Datacenter (Azure compute) MS Datacenter (On-premises) Application/ Browser App code/ Tools App code/ Tools (ASP.NET) (ASP.NET) T-SQL (TDS) SQL Azure Code Near Windows Azure Windows Azure Data Sync App Code App Code SQL Azure Astoria/REST - EDM HTTP/S T-SQL (TDS) SOAP/REST HTTP/S SQL Azure Access from within and outside MS Datacenter (On-premises & Azure Compute) App Code App Code (ASP.NET) (ASP.NET) T-SQL (TDS) SQL Azure SQL Azure Code Far Hybrid SQL Azure Database Management Application Migration from OnPremises SQL Server to SQL Azure in the Cloud Database Migration from SQL Server to SQL Azure CTP1 (Now) Introducing SQL Azure Data Sync ”Synchronization of SQL Server and SQL Azure Databases” SQL Azure Database On-Premises (Headquarters) Remote Offices CTP2 Sync Retail Stores SQL Azure Data Sync On-Premises to Cloud Symmetry SQL Server to SQL Azure 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 Sync SQL Azure to SQL Azure Synchronization Benefits • Geo-synchronization of data across data centers • Scale-out read or read/write 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 Sync End to End Scenarios http://azure.com Offline Applications On-Premises Applications Sync Sync SQL Azure Database http://azure.com Retail & Remote Offices Data Tier Applications Data-Tier Application Project (Departmental apps in V1) 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 Visual Studio Build .dacpac Deploy SQL Azure Software Requirements What’s in a DACPAC? Application Deployment to SQL Azure using Data Tier Applications