Integration Runtime for SQLServer on Azure VM

grajee 346 Reputation points
2021-03-15T19:14:56.553+00:00

All,

In order to avoid the network blip and migrate data efficiently from On-Prem SQLServer to AzureSQL PaaS, I was thinking of backing up and restoring the databases to a SQLServer on AzureVM and using this as the source instead of using the On-Prem SQLServer as the source. We do have a Self-Hosted On-Prem IR.

By doing so, I was hoping to by pass the On-Prem IR. Is this possible? Wouldnt AutoResolveIntegrationRuntime be good enough for this purpose.

If I'm forced to use the Self-Hosted IR then it seems to be defeating the purpose of restoring the databases onto AzureVM.

Thanks,
grajee

P.S:- https://learn.microsoft.com/en-us/azure/data-factory/concepts-integration-runtime#copy-activity

Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,084 questions
0 comments No comments
{count} votes

Accepted answer
  1. Vaibhav Chaudhari 38,681 Reputation points
    2021-03-16T02:59:08.277+00:00

    Even if SQL is installed on VM, I don't see any document stating that connecting to that SQL is possible without using IR.

    Try if you can connect to it using Managed virtual network as folks here are discussing about it. Do upvote the feedback.

    https://feedback.azure.com/forums/270578-data-factory/suggestions/37105363-data-factory-should-be-able-to-use-vnet-without-re


    Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

    0 comments No comments

0 additional answers

Sort by: Most helpful