Create MI link from Azure SQL Managed Instance to SQL Server 2022 to replicate a database

Описание: In this demo you will see how can you use SSMS to create MI link from Azure SQL Managed Instance to SQL Server 2022. This can be used to replicate data from SQL MI to SQL Server for any purposes, including database migration from Azure to on-premises, for example. This can be highly effective in meeting cloud exit requirements while minimizing latency and downtime.
Note: To be able to create MI link to SQL Server 2022, Update Policy of your Azure SQL Managed Instance needs to be set to "SQL Server 2022".

Learn more at: https://aka.ms/sqlmi-link

Video by Djordje Jeremic.

📩 SQL MI Newsletter | https://aka.ms/sqlmi-letter
🍿 Watch next | Planned failover (DR drill) between SQL Server 2022 and SQL MI    • Planned failover (DR drill) between SQL Se...  
📚 Read next | Free offer for Azure SQL Managed Instance: https://aka.ms/sqlmi-free

Chapters:
00:08 Introduction
00:24 Use SSMS to create MI link from SQL MI to SQL Server 2022
02:22 MI link successfully created
03:09 Verifying newly created database in SQL Server 2022

Recommended content:
Link feature for SQL MI documentation: https://aka.ms/mi-link
Test network connectivity for MI link: https://aka.ms/sqlmi-link-tnc
Prepare your environment for a link: https://learn.microsoft.com/azure/azu...
Transparent data encryption for SQL Managed Instance: https://learn.microsoft.com/azure/azu...
What's new in SQL MI: https://aka.ms/sqlmi-new