question

SanthamoorthyM-9171 avatar image
1 Vote"
SanthamoorthyM-9171 asked Cathyji-msft edited

Azure SQL Managed instance - linked server for Oracle DB

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-databaseazure-migrate
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.

AlbertoMorillo avatar image
1 Vote"
AlbertoMorillo answered AlbertoMorillo edited

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.



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.

BjoernPeters avatar image
1 Vote"
BjoernPeters answered BjoernPeters rolled back

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://docs.microsoft.com/en-us/sql/relational-databases/linked-servers/linked-servers-database-engine?view=sql-server-ver16

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

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.