Data Migration to Azure SQL and Azure SQL Managed Instance - June 19 2020

Data Migration to Azure SQL and Azure SQL Managed Instance - June 19 2020

• 3.
  Fridays, 11:30AM –12:30PM May 8th through July 24 Breaking for July 3 and July 31. Series Extended from Sept 4 through October 30 Coming up: June 19 - Tim McAliley - Migrate Your Data to Azure SQL DB / Azure SQL Managed Instance Jun 26 – Mark Brown Azure Cosmos DB July 10 - Louis Berman, Azure Cosmos DB/Azure Functions and Blazor July 17 - Jay Kumar – Azure Kubernetes Service RSVP/Information at Northern Virginia SQL User Group meetup page – www.meetup.com/novasql Slide Downloads or information about slides/blogs are also on the meetup page Session Recordings are Located on YouTube at “AzureCloud Events” and the link posted to www.meetup.com/novasql
• 4.
  AzureCloud Events (“AzureCloud”is one word) User group webinars and virtual conference content
• 5.
  Check – NOVASQL Meetup - www.meetup.com/novasql • Weekly NOVASQL webinars through July, then September through August Check - Artificial Intelligence / Machine Learning Meetup – www.meetup.com/aimil • Monthly virtual meetups Global Azure DataFest – July 2 (virtual conference) Global Azure AI/ML Fest – July 31 (virtual conference) Conference info is on the Meetup pages
• 6.
  Thank You! We AreAlways Looking for Talent - https://careers.microsoft.com Contact Info- • LinkedIn - https://www.linkedin.com/in/timothymcaliley/ • Twitter - @sysframeworks and @novasql • Email – timothy.mcaliley@microsoft.com
• 7.
  Database Migration Journeyand Tools Azure Database Migration Service Data Migration Assistant Database Experimentation Assistant Backup / Restore SQL Server Management Studio Data Migration Cookbook References & Further Learning **Slide location is on www.meetup.com/novasql AGENDA
• 8.
  Migrate to Azure SQLDatabase
• 9.
  • Select amigration strategy • Find recommended tools
• 10.
  DMS, DMA, SSMS,DEA Azure SQL Database Managed Instance Azure Hybrid Benefit for SQL Server Database Migration Service (DMS) Enables offline & online migrations to Azure SQL Database Data Migration Assistant (DMA) Assess database compatibility and feature parity SQL Server Management Studio (SSMS) Integrated environment for managing SQL Server Database Experimentation Assistant (DEA) Evaluate target version of SQL Server for a given workload Tools and services for your migration journey On-premises data https://datamigration.microsoft.com
• 11.
  On-premises Assessment (SSMA, DMA, DEA) AzureDatabase Migration Service Microsoft Azure
• 12.
  Accelerate your transitionto Azure A seamless, end-to-end solution for moving on-premises databases to Azure Orchestration Scale migration Near-zero downtime Homogeneous sources Heterogeneous sources
• 13.
  Fully managed Azureservice platform for seamless and frictionless data migration at scale Database migrations with near-zero downtime Migrate SQL Server & 3rd party databases to Azure SQL Database Built for scale and reliability Expedite migration with Azure Database Migration Service Target DB Source DB Azure SQL Database SQL Server DMS Copy local backup to Azure storage Azure Storage Create local backup Restore backup to Azure SQL DB
• 14.
  Seamless, end toend solution | Near-zero downtime | Resilient | Migrate at-scale from multiple sources Migrating databases using Azure Database Migration Services On-premises SQL Server 2005 - 2017 Assessment SSMA, DEA & DMA Azure Database Migration Service Cosmos DB My SQL SQL Server on Azure VMs Azure SQL Database Azure Database for MySQL, PostgreSQL and MariaDB
• 15.
  Azure Database MigrationService On-premises network Subnet used for DMS On-PremiseCustomer SubscriptionMicrosoft Subscription Azure Storage Account Service Bus Queue DMS Resource Provider CLI commands PowerShell Virtual Machine Azure Portal My M y
• 16.
  Assess on-premises SQLServer instance(s) for migrating to Azure SQL database(s) Discover issues that can affect an upgrade Migrate an on-premises SQL Server instance to a modern SQL Server instance Data Migration Assistant
• 17.
  Database Experimentation Assistant
• 18.
  Subnet used forMI Virtual Network (VNET) SQL Server to Azure SQL Database Managed Instance example 1 2 3 4 Subnet used for DMS Azure Blob Storage SMB Network Share On-premises Cloud network SQL DB Managed Instance 2 3 1 4
• 19.
  Migrate a compatibledatabase using SQL Server Management Studio Use SSMS to deploy to Azure SQL Database Use SSMS to export a BACPAC and then import it to Azure SQL Database SQL Server Management Studio 2. Import 1. DeployOR 1. Export Target DB Source DB Azure SQL Database SQL Server SSMS
• 20.
  Migrate an on-premisesSQL Server database to Azure SQL Database The Migration Cookbook describes various approaches you can use to migrate an on-premises SQL Server database to the latest Azure SQL Database Update Download: https://azure.microsoft.com/en- us/resources/choosing-your-database-migration- path-to-azure/en-us/ Migration Centre: https://azure.microsoft.com/en- us/migration/ Migration Cookbook
• 21.
  References & FurtherLearning Azure - https://azure.microsoft.com Azure SQL Database https://docs.microsoft.com/en-us/azure/sql-database/sql-database-technical-overview Azure Database Migration Service - https://azure.microsoft.com/en-us/services/database-migration/#documentation Data Migration Assistant - https://docs.microsoft.com/en-us/sql/dma/dma-overview?view=sql-server-ver15 Data Experimentation Assistant - https://docs.microsoft.com/en-us/sql/dea/database-experimentation-assistant- overview?view=sql-server-ver15 Azure Database Migration Cookbook - https://azure.microsoft.com/en-us/resources/choosing-your-database-migration- path-to-azure/en-us/ Azure Migration Center - https://azure.microsoft.com/en-us/migration/ Azure Regions - https://azure.microsoft.com/en-us/global-infrastructure/regions/ Learning / Training - https://docs.microsoft.com/en-us/learn/