Hello @J Prusty ,
Welcome to the Microsoft Q&A platform.
You can use Azure Data Factory to copy data among data stores located on-premises and in the cloud.
Note: If your data store is located inside an on-premises network, an Azure virtual network, or Amazon Virtual Private Cloud, you need to configure a self-hosted integration runtime to connect to it.
For more details, refer Copy data to and from SQL Server by using Azure Data Factory.
Hope this helps. Do let us know if you any further queries.
Please don’t forget to
Accept Answer and
Up-Vote wherever the information provided helps you, this can be beneficial to other community members.