Managed Instance Link - Seamless migration to Azure
summary
Managed Instance Link migrates on‑prem SQL Server (2016, 2019, 2022) to Azure SQL Managed Instance by creating a certificate‑based trust, seeding a full backup over VPN/ExpressRoute, and using distributed availability groups for near real time asynchronous replication; SSMS 19+ automates the steps but you can script them. Each database needs its own link and a managed instance supports 100 links per instance. Read‑only secondaries allow testing, cutover makes the target read‑write (business‑critical cutovers ≈ seconds), and SQL Server 2022 supports reverse migration back on‑prem.
AI-written summary · about
chapters (10)
- 0:00Session introduction
- 3:10Azure SQL deployment options
- 6:42Migration tools overview
- 10:22Understanding SQL MI link
- 14:40Underlying technology
- 18:36Strategic migration benefits
- 22:31Comparison with log replay
- 29:17Prerequisites and setup
- 32:34Live migration demonstration
- 47:15Conclusion and Q&A
related talks
50mManaged Instance Link - Seamless migration to Azure
44mThe Ultimate Freedom of Movement with SQL Server 2022 and Azure SQL Managed Instance- 44mThe Ultimate Freedom of Movement with SQL Server 2022 and Azure SQL Managed Instance
48mSQL Server 2022 - the most Azure-enabled SQL Server yet
19mThere and back again: SQL Server 2022 - Managed Instance
23mReturn ticket from SQL Managed Instance to SQL Server – One-Click Reverse Migration and DR- 23mReturn ticket from SQL Managed Instance to SQL Server – One-Click Reverse Migration and DR
44mSQL Managed Instance: Fully managed SQL Server in Azure