Azure SQL Managed instance - linked server for Oracle DB

Santhamoorthy M 161 Reputation points
2022-05-26T14:30:34.917+00:00

I'm working on the on-premise sql server db migration to Azure SQL MI using Azure DMS and sql server is having linked servers to connect Oracle DB. Could someone please confirm if I can create linked server to connect Oracle DB in Azure SQL MI. If yes, any changes required before migration.

Azure SQL Database
Accepted answer
  1. Alberto Morillo 32,806 Reputation points MVP
    2022-05-26T14:44:41.587+00:00

    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. You cannot have a linked server to an Oracle server on Azure Managed Instance.

    1 person found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Bjoern Peters 8,781 Reputation points
    2022-05-26T14:40:26.393+00:00

    Hi there,

    I do not have experience with that, so my answer is based on my understanding of what I know and have read.

    Yes, that should be possible.
    Regarding this page, it should be possible to connect from Azure SQL MI to the on-premise Oracle server.
    https://learn.microsoft.com/en-us/sql/relational-databases/linked-servers/linked-servers-database-engine?view=sql-server-ver16

    Edit:
    I revoke my answer:
    As @Alberto Morillo stated... I dived deeper into that topic and found those constraints... I was misled by that graphic and the OLEDB/DLL thing.
    Sorry.

    1 person found this answer helpful.
    0 comments