question

SumitYadam-7207 avatar image
0 Votes"
SumitYadam-7207 asked learn2skills commented

Can Azure SQL database access on-premise SQL server tables in a query?

Hi,

We are syncing data to and from Salesforce to on-premise sql server using ADF and Azure SQL server. We are looking for a way to connect on-premise sql server via an external data source (linked server) so that we can query the on-premise data in Azure SQL stored procedures. Is there a way to do that?

Our database is behind firewall so we also need the IP address range of Azure SQL server to white list in our domain firewall. Where can I find this in azure portal?

Thank you.

azure-sql-databaseazure-firewall
· 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.

To follow-up, Please let us know if you have further query on this.
Please don’t forget to Accept the answer

0 Votes 0 ·

1 Answer

learn2skills avatar image
0 Votes"
learn2skills answered

Hi @SumitYadam-7207
It is possible to create Linked Server in Azure SQL Managed Instance?
The answer is Yes!!! and to create it you only need to follow up the instructions provided in this URL

Linked Server alternative in Sql Azure database
SQL Linked Server: Sending Data from On-Premises SQL Databases to Azure SQL Databases
create linked server in azure sql database

If the Answer is helpful, please click Accept Answer and up-vote, this can be beneficial to other community members.


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.