The Ultimate Freedom of Movement with SQL Server 2022 and Azure SQL Managed Instance
summary
Mi Link provides bidirectional, database-scoped replication between SQL Server and Azure SQL Managed Instance using distributed availability groups and certificate-based authentication, with VPN connectivity required and ports opened. Replication is near real-time and asynchronous by default, flips to synchronous for minimum-downtime migrations, and supports online failover between SQL Server 2022 and Managed Instance (online failback in preview, offline failback GA via backup/restore). Tooling includes SSMS wizards and PowerShell scripts, limits are 100 links per managed instance, and demos show instant seeding, seamless failover, and successful read-only offload for analytics.
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
50mManaged Instance Link - Seamless migration to Azure
23mReturn ticket from SQL Managed Instance to SQL Server – One-Click Reverse Migration and DR
48mSQL Server 2022 - the most Azure-enabled SQL Server yet
50mAzure SQL Managed Instance Roadmap- 23mReturn ticket from SQL Managed Instance to SQL Server – One-Click Reverse Migration and DR
44mSQL Managed Instance: Fully managed SQL Server in Azure