Forum Discussion

Manu's avatar
Manu
Copper Contributor
May 28, 2025

On-Prem SQL server db to Azure SQL db

Hi,

I'm trying to copy data from on-prem sql server db to azure sql db using SHIR and ADF.

I've stood up ADF, SQL server and a db in Azure.

As per my knowledge we need to download https://www.microsoft.com/en-us/download/details.aspx?id=39717 and install SHIR in on-prem server and register that SHIR with ADF key.

The On-prem SQL server has TCP/IP connection enabled.

What other set up i need to do in on-prem server such as firewall, IP, port configurations?


The on-prem sql server is in different network which is not connected to our network.

1 Reply

  • tmm008's avatar
    tmm008
    Copper Contributor
    May 30, 2025

    I had to register a private endpoint for the on-premise server to access Data Factory for the SHIR key to work.

    https://learn.microsoft.com/en-us/azure/data-factory/data-factory-private-link

     

Resources