In this video we will demo how Azure SQL Managed Instance link (short MI link) can be used to create readonly database replicas of a database hosted on SQL Server.

In general Link feature for Azure SQL Managed Instance offers near realtime data replication from SQL Server to Azure SQL Managed Instance or viceversa. MI link can be used in read scaleout scenarios, and also in hybrid disasterrecovery scenarios, between SQL Server hosted anywhere and Azure SQL Managed Instance link. MI link can also be used for migration of databases from SQL Server to Azure SQL Managed Instance.

Learn more at: https://aka.ms/milink

Video by Djordje Jeremic.

Chapters:
Introduction: 00:08
Create readonly database replica with SSMS: 01:22
Verification of MI link after successful creation: 05:27
Creating the second readonly database with MI link: 06:30
Showing near realtime replication MI link offers 07:50
Conclusion 08:30

Watch next | Becoming an Azure Cloud DBA    • Upgrade Your SQL Server DBA Skills to...  
Read next | Online disaster recovery between SQL Server 2022 and SQL Managed Instance https://aka.ms/sqlmilink
SQL MI Newsletter | https://aka.ms/sqlmiletter

Recommended content:
Free offer for Azure SQL Managed Instance: https://aka.ms/sqlmifree
Test network connectivity for MI link: https://aka.ms/sqlmilinktnc
Transparent data encryption (TDE) for SQL MI: https://learn.microsoft.com/azure/azu...
Nextgen General Purpose documentation: https://learn.microsoft.com/azure/azu...
What's new in SQL MI: https://learn.microsoft.com/azure/azu...