Return ticket from SQL Managed Instance to SQL Server – One-Click Reverse Migration and DR
summary
Live demos show one‑click reverse migration and DR using the Mi link feature, creating links from SQL Server to SQL Managed Instance and back by running an SSMS wizard that provisions distributed availability groups. Supported sources are SQL Server 2016+ and reverse migration requires SQL Server 2022; demos perform planned manual failover, writable primary swap, and near‑real‑time replication with DNS aliasing for transparent connection routing. All scripted steps are generated by SSMS and the workflow completes successfully in the demos.
AI-written summary · about
chapters (7)
- 0:00Mi Link feature
- 1:54Mi Link capabilities
- 4:21SQL Server to MI replication demo
- 9:05Disaster Recovery failover
- 14:03Reverse replication to SQL Server
- 18:42Application failover with DNS
- 20:05Q&A on licensing & encryption
related talks
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
44mThe Ultimate Freedom of Movement with SQL Server 2022 and Azure SQL Managed Instance
19mThere and back again: SQL Server 2022 - Managed Instance
50mManaged Instance Link - Seamless migration to Azure- 44mThe Ultimate Freedom of Movement with SQL Server 2022 and Azure SQL Managed Instance
50mDiscover what's new in Azure SQL Managed Instance through an exciting Demo Party!
19mTake Control of your Azure SQL Managed Instance Migration using the Log Replay Service