question

DanielNascimento-5742 avatar image
0 Votes"
DanielNascimento-5742 asked SaurabhSharma-msft commented

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

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

1 Answer

AlbertoMorillo avatar image
0 Votes"
AlbertoMorillo answered SaurabhSharma-msft commented

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

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

@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 Votes 0 ·