Skip to content

Commit a255a6d

Browse files
committed
adding samples links, and text for sql mi link
1 parent 8cdd0be commit a255a6d

2 files changed

Lines changed: 9 additions & 5 deletions

File tree

azure-sql/managed-instance/managed-instance-link-feature-overview.md

Lines changed: 7 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -25,9 +25,11 @@ If you have product improvement suggestions or comments, or you want to report i
2525
2626
## Overview
2727

28-
The Managed Instance link feature uses distributed availability groups to extend your SQL Server on-premises Always On availability group hosted anywhere to Azure SQL Managed Instance in a safe and secure manner, replicating data in near real-time.
28+
The Managed Instance link feature uses distributed availability groups to extend your SQL Server on-premises Always On availability group hosted anywhere to Azure SQL Managed Instance in a safe and secure manner, replicating data in near real-time.
2929

30-
The link supports single node SQL Server instances without existing availability groups, and also multiple-node SQL Server instances with existing availability groups. Through the link, you can use the latest benefits of Azure without migrating your entire SQL Server data estate to the cloud.
30+
The link supports single node SQL Server instances without existing availability groups, and also multiple-node SQL Server instances with existing availability groups. Through the link, you can use the latest benefits of Azure without migrating your entire SQL Server data estate to the cloud.
31+
32+
Though the link supports replicating one database per link, it's possible to replicate multiple databases from a single instance of SQL Server to a single SQL managed instance by configuring multiple links - one link for each database you want to replicate.
3133

3234
The link feature currently offers the following functionality:
3335

@@ -44,7 +46,7 @@ The Managed Instance link is supported on both the General Purpose and Business
4446

4547
The following table lists the functionality of the link feature and the supported SQL Server versions:
4648

47-
| SQL Server version | Operating system (OS) | One-way replication | Disaster recovery | Servicing update requirement |
49+
| SQL Server version | Operating system (OS) | One-way replication (for migration & DR) | Disaster recovery with fail back | Servicing update requirement |
4850
| --- | --- | --- | --- | --- |
4951
| SQL Server 2022 (16.x) | Windows Server and Linux | Generally available | [Must sign up for limited public preview](https://aka.ms/mi-link-dr-preview-signup) | SQL Server 2022 RTM |
5052
| SQL Server 2019 (15.x) | Windows Server only | Generally available |N/A | [SQL Server 2019 CU20 (KB5024276)](https://support.microsoft.com/topic/kb5024276-cumulative-update-20-for-sql-server-2019-4b282be9-b559-46ac-9b6a-badbd44785d2) |
@@ -149,7 +151,8 @@ Data replication limitations include:
149151
Configuration limitations include:
150152

151153
- If there are multiple SQL Server instances on a server, it's possible to configure a link with each instance, but each instance must be configured to use a separate database mirroring endpoint, with a dedicated port per instance. Only the default instance should use port 5022 for the database mirroring endpoint.
152-
- Only one database can be placed into a single availability group for one Managed Instance link.
154+
- Only one database can be placed into a single availability group for one Managed Instance link. However, it's possible to replicate multiple databases in a single SQL Server instance by establishing multiple links.
155+
- A single managed instance supports up to 100 links from multiple SQL Server instances.
153156
- A Managed Instance link can replicate a database of any size if it fits into the chosen storage size of the target SQL Managed Instance deployment.
154157
- Managed Instance link authentication between SQL Server and SQL Managed Instance is certificate-based and available only through an exchange of certificates. Using Windows authentication to establish the link between the SQL Server instance and the managed instance isn't supported.
155158
- Only [VNet-local endpoint](connectivity-architecture-overview.md#vnet-local-endpoint) is supported to establish a link with SQL Managed Instance.

docs/samples/adventureworks-install-configure.md

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -4,7 +4,7 @@ description: Follow these instructions to download and install AdventureWorks sa
44
author: MashaMSFT
55
ms.author: mathoma
66
ms.reviewer: randolphwest
7-
ms.date: 03/30/2023
7+
ms.date: 05/08/2023
88
ms.service: sql
99
ms.subservice: samples
1010
ms.topic: conceptual
@@ -34,6 +34,7 @@ If you're not sure what you need, start with the OLTP version that matches your
3434

3535
| OLTP | Data Warehouse | Lightweight |
3636
| --- | --- | --- |
37+
| [AdventureWorks2022.bak](https://github.com/Microsoft/sql-server-samples/releases/download/adventureworks/AdventureWorks2022.bak) | [AdventureWorksDW2022.bak](https://github.com/Microsoft/sql-server-samples/releases/download/adventureworks/AdventureWorksDW2022.bak) | [AdventureWorksLT2022.bak](https://github.com/Microsoft/sql-server-samples/releases/download/adventureworks/AdventureWorksLT2022.bak) |
3738
| [AdventureWorks2019.bak](https://github.com/Microsoft/sql-server-samples/releases/download/adventureworks/AdventureWorks2019.bak) | [AdventureWorksDW2019.bak](https://github.com/Microsoft/sql-server-samples/releases/download/adventureworks/AdventureWorksDW2019.bak) | [AdventureWorksLT2019.bak](https://github.com/Microsoft/sql-server-samples/releases/download/adventureworks/AdventureWorksLT2019.bak) |
3839
| [AdventureWorks2017.bak](https://github.com/Microsoft/sql-server-samples/releases/download/adventureworks/AdventureWorks2017.bak) | [AdventureWorksDW2017.bak](https://github.com/Microsoft/sql-server-samples/releases/download/adventureworks/AdventureWorksDW2017.bak) | [AdventureWorksLT2017.bak](https://github.com/Microsoft/sql-server-samples/releases/download/adventureworks/AdventureWorksLT2017.bak) |
3940
| [AdventureWorks2016.bak](https://github.com/Microsoft/sql-server-samples/releases/download/adventureworks/AdventureWorks2016.bak) | [AdventureWorksDW2016.bak](https://github.com/Microsoft/sql-server-samples/releases/download/adventureworks/AdventureWorksDW2016.bak) | [AdventureWorksLT2016.bak](https://github.com/Microsoft/sql-server-samples/releases/download/adventureworks/AdventureWorksLT2016.bak) |

0 commit comments

Comments
 (0)