Learn Live: Migrate SQL workloads to Azure Managed Instances

on YouTube ↗01h 02m

" summary

Migrating SQL Server to Azure SQL Managed Instance uses native backup/restore with Azure Data Studio plus the Azure SQL Migration extension, the Database Migration Service and a self‑hosted integration runtime that copies backups to Azure Storage and DMS restores them; migration supports near‑100% compatibility (memory‑optimized tables may force business critical), sizing recommendations arrive from performance capture (example: A4/4 vCore, 32 GB), deployment can take up to six hours and cutover supports tail‑log backups. Azure Data Studio Database Migration Service self-hosted integration runtime

AI-written summary · about

" chapters (36)

1. 0:00Introduction
2. 2:10Azure SQL
3. 8:25Azure Managed Instance
4. 9:35Azure Managed Instance Features
5. 11:15Benefits of Azure SQL
6. 14:35Licensing Options
7. 15:42Service Tiers
8. 17:03Hardware Specs
9. 17:20Database Compatibility
10. 18:00High Level Connectivity
11. 19:11Integration with other cloud services
12. 19:41Location of applications
13. 20:11Create a manage instance
14. 20:39Azure SQL portal
15. 25:08Estimated cost
16. 26:17Create Azure Managed Instance
17. 27:04Add Virtual Machine
18. 28:12Summary
19. 29:46Migration Tools
20. 31:29Scenario
21. 32:21Azure Data Studio
22. 33:20Install Azure Data Studio
23. 36:20Select Databases
24. 37:53Assessment Results
25. 38:40Viewing the Results
26. 39:42Get Azure Recommendation
27. 41:08Create Azure SQL Managed Instance
28. 41:24Encrypted databases
29. 43:06Azure SQL Migration Extension
30. 45:45Azure Connection Information
31. 46:28Azure Database Migration Service
32. 48:22Installation of SelfHosted Integration Runtime
33. 49:55Source Credentials
34. 51:10Database Migration
35. 51:50Database Cutover
36. 52:48Demo

" related talks

• 46mSQL Migrations to Azure Made EasyDavid Levy · SQLBits 2023
• 50mSQL Modernization Journey with Tools, Assets & Migration Best PracticesDes FitzGerald, Ajith Krishnan, Neel Ball · SQLBits 2024
• 57mDe-risk Your Azure SQL Migration: 5 Critical ConsiderationsKevin Kline, Dustin Dorsey, Denis McDowell · SQLBits 2020
• 50mSQL Server to Azure SQL: Performance and AvailabilityBob Ward, Anna Hoffman · SQLBits 2020
• 19mTake Control of your Azure SQL Managed Instance Migration using the Log Replay ServiceRob Carrol · SQLBits 2023
• 52mAzure Sql DB Managed instance, a different sql server?Gonzalo Bissio · Global Azure 2021
• 50mMigrating data solutions to the cloud - a checklist.Kristina Mishra · SQLBits 2019
• 49mIt keeps getting easier to move Oracle and Open Source workloads to AzureDavid Levy · SQLBits 2023