Alternative to Linked Servers

Question

question

DanielNascimento-5742 asked Oct 14, '21 SaurabhSharma-msft commented Oct 25, '21

Alternative to Linked Servers

Hello,

We are thinking about migrating our SQL Server databases to PaaS service, the fact is that those services do not support Linked services which is a requirement (for now) in our environment.

We really want to use the PaaS (either managed instance or Azure SQL database), is there any workaround to this? I know managed instance supports linked server to other SQL Databases, but we want to configure the linked server to IBM Informix wich is how we currently have it on-premises.

Is there any alternative for linked server that is supported by Managed instance?

azure-sql-database

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 1 · 2021-10-14T18:12:05.03Z

AlbertoMorillo answered Oct 14, '21 SaurabhSharma-msft commented Oct 25, '21

When creating a linked server on Azure Managed Instance, you are only able to use the SQL provider (driver) to connect to Azure SQL Database, SQL Server, Azure Synapse, SQL serverless or Azure SQL Managed Instance. This is explained here and here.

You cannot install other providers on Azure Managed Instance. It is a limitation. To have more information about limitations of linked servers on Azure Managed Instances please click here.

My suggestion is to use a SQL Server IaaS VM instead if linked servers are important .

· 1

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SaurabhSharma-msft · Oct 25, 2021 at 06:26 PM

@DanielNascimento-5742

Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.

Thanks
Saurabh

0 ·

question