0

I have a Azure SQL online SQL-database. How can I create a linked server to a DB2 server with a VPN (Fortigate). I have checked some tutorials, but my SSMS does not have a folder "linked Servers", because it is Azure-SQL. Also running EXEC sp_addlinkedserver is not working, because it leads to Could not find stored procedure 'sp_addlinkedserver'.

How can I link these two databases to do simple Queries with them? Inserting is not really necessary to DB2.

I am currently working with a combo of python/pandas DataFrame joining and synchronizing/uploading the data from DB2 to Azure-SQL, which requires heavy, prone to error python code and lot of storage on Azure-SQL.

Improve this question
1
  • It is not supported to create liked server in azure sql database. You need to create external table based on the other database and query it. Commented Nov 6, 2023 at 14:48

2 Answers 2

Reset to default
0

You cannot create a linked server on Azure SQL Database as the feature it is not supported. Azure SQL Managed Instance does support linked servers but 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.

Only on a SQL Server VM you will be able to create a linked server to connect to a DB2 server.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

0

Since you are uploading/synchronizing the data from DB2 an option would be to use an Azure Data Factory to upload the DB2 data to Azure then work with it from there.

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.