Microsoft OLE DB Provider for DB2

%3CLINGO-SUB%20id%3D%22lingo-sub-2508065%22%20slang%3D%22en-US%22%3EMicrosoft%20OLE%20DB%20Provider%20for%20DB2%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2508065%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%20I%20want%20to%20migrate%20an%20SQL%20Server%20on%20premises%20data%20base%20to%20Azure%20Manage%20Instance%2C%20but%20on%20premises%20I%20have%20a%20linked%20server%20that%20connect%20to%20DB2.%20Its%20is%20possible%20to%20connect%20to%20DB2%20from%20Azure%20SQL%20Manage%20Instance%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Jose0912_0-1625158851133.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F292978i2E0E65B20E665884%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Jose0912_0-1625158851133.png%22%20alt%3D%22Jose0912_0-1625158851133.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2524487%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20OLE%20DB%20Provider%20for%20DB2%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2524487%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F812749%22%20target%3D%22_blank%22%3E%40Jose0912%3C%2FA%3E%26nbsp%3B--%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ELinked%20servers%20to%20other%20RDBMS%20is%20not%20currently%20supported%20in%20Azure%20SQL%20Managed%20Instance.%26nbsp%3B%20This%20limitation%20is%20documented%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-sql%2Fmanaged-instance%2Ftransact-sql-tsql-differences-sql-server%23functionalities%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehere%3C%2FA%3E.%26nbsp%3B%20Take%20care.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi,

  I want to migrate an SQL Server on premises data base to Azure Manage Instance, but on premises I have a linked server that connect to DB2. Its is possible to connect to DB2 from Azure SQL Manage Instance?

 

Regards

 

Jose0912_0-1625158851133.png

 

1 Reply

Hi @Jose0912 --

 

Linked servers to other RDBMS is not currently supported in Azure SQL Managed Instance.  This limitation is documented here.  Take care.