Azure SQL Managed Instance Link is a service that allows you to create a read-only replica of your on-premise SQL Server database in the cloud. This allows you to offload read-only workloads from your on-premise database to the cloud. With Managed Instance Link, you can ensure that your on-premise and cloud-based databases are always in sync. This makes it easier to access data in the cloud and provides a more cost-effective solution for running read-only workloads. Additionally, Managed Instance Link also provides enhanced security, scalability, and availability for your cloud-based database.
Want to leverage the power of the cloud with your on-prem SQL Server? Azure SQL Managed Instance may be the answer for you! Dani joins us to talk about why MI Link can help bridge the two.
What is Azure SQL Managed Instance? - Azure SQL Managed Instance | Microsoft Learn
Managed Instance link feature overview - Azure SQL Managed Instance | Microsoft Learn
Replication can be configured by using SQL Server Management Studio or by executing Transact-SQL statements on the publisher. You cannot configure replication by using the Azure portal. Replication can only use SQL Server authentication logins to connect to Azure SQL Database. Replicated tables must have a primary key.
A read replica server can be created using the following steps:
The link feature for Azure SQL Managed Instance connects your SQL Servers hosted anywhere to SQL Managed Instance, providing near real-time data replication to the cloud. Some functionality of the link is generally available, while some is currently in preview.
Transactional replication is a feature of Azure SQL Managed Instance and SQL Server that enables you to replicate data from a table in Azure SQL Managed Instance or a SQL Server instance to tables placed on remote databases. This feature allows you to synchronize multiple tables in different databases.