SQL Server read scale-out to Azure with SQL Managed Instance link feature
In this video we will demo how Azure SQL Managed Instance link (short MI link) can be used to create read-only database replicas of a database hosted on SQL Server.
In general Link feature for Azure SQL Managed Instance offers near real-time data replication from SQL Server to Azure SQL Managed Instance or vice-versa. MI link can be used in read scale-out scenarios, and also in hybrid disaster-recovery 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/mi-link
Video by Djordje Jeremic.
Chapters:
Introduction: 00:08
Create read-only database replica with SSMS: 01:22
Verification of MI link after successful creation: 05:27
Creating the second read-only database with MI link: 06:30
Showing near real-time 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/sqlmi-link
📩 SQL MI Newsletter | https://aka.ms/sqlmi-letter
Recommended content:
Free offer for Azure SQL Managed Instance: https://aka.ms/sqlmi-free
Test network connectivity for MI link: https://aka.ms/sqlmi-link-tnc
Transparent data encryption (TDE) for SQL MI: https://learn.microsoft.com/azure/azu...
Next-gen General Purpose documentation: https://learn.microsoft.com/azure/azu...
What's new in SQL MI: https://learn.microsoft.com/azure/azu...