Managed Instance Link - Seamless migration to Azure
summary
Azure SQL Managed Instance Link replicates individual databases from SQL Server (2016, 2019 and 2022; 2017 coming) to Managed Instance using distributed availability groups and certificate trust, creating one link per database (up to 100). Migration seeds from a full backup, requires full recovery mode, and prefers ExpressRoute for seeding. Replication is near‑real‑time and cutover is almost instantaneous on Business Critical tier; reverse migration from SQL Server 2022 is supported. Demo shows successful seeding, live replication and a clean failover.
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
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
50mAzure SQL Managed Instance Roadmap
44mSQL Managed Instance: Fully managed SQL Server in Azure