Return ticket from SQL Managed Instance to SQL Server – One-Click Reverse Migration and DR
summary
Live demos show a new Mi link that sets up near real-time replication between SQL Server (2016+) and Azure SQL Managed Instance using distributed availability groups, with SSMS wizards that auto-create AGs and emit runnable scripts. The preview adds one-click reverse failover and the ability to create links from MI back to SQL Server 2022 so the secondary becomes writable and replicates back, supports TDE with key provisioning, suggests DNS aliasing for seamless app routing, and honors hybrid passive licensing.
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- 44mThe Ultimate Freedom of Movement with SQL Server 2022 and Azure SQL Managed Instance
50mManaged Instance Link - Seamless migration to Azure
48mSQL Server 2022 - the most Azure-enabled SQL Server yet
50mDiscover what's new in Azure SQL Managed Instance through an exciting Demo Party!
50mAzure SQL Managed Instance Roadmap