The Ultimate Freedom of Movement with SQL Server 2022 and Azure SQL Managed Instance
summary
A hybrid bridge called Mi link replicates user databases near real‑time from SQL Server 2016–2022 into Azure SQL Managed Instance using distributed availability groups, offering the industry’s first bidirectional data movement and almost instantaneous failover for migrations and DR between SQL Server 2022 and Managed Instance. The demo shows read‑only secondaries in Azure, switch to synchronous for cutover, and a working online failback (preview). Requirements: VPN connectivity, cert exchange, max 100 links per instance; 2016/2019 one‑way, 2022 full bi‑directional.
AI-written summary · about
chapters (11)
- 0:00Start
- 7:13Link is based on distributed Availability Groups
- 8:06Supported SQL Servers and editions
- 12:52Feature characteristics
- 14:27Link networking requirements
- 16:40Link deeper technical overview
- 22:34Failover orchestration
- 25:37Failing back to SQL Server 2022 instance
- 39:13DR drill - sequence diagram
- 40:48Disaster recovery through forced failover
- 42:08Advanced scenarios with the link feature (recap)
related talks
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
19mThere and back again: SQL Server 2022 - Managed Instance
50mManaged Instance Link - Seamless migration to Azure- 50mManaged Instance Link - Seamless migration to Azure
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
- 23mReturn ticket from SQL Managed Instance to SQL Server – One-Click Reverse Migration and DR