question

grajee avatar image
0 Votes"
grajee asked ·

Integration Runtime for SQLServer on Azure VM

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://docs.microsoft.com/en-us/azure/data-factory/concepts-integration-runtime#copy-activity


azure-data-factoryazure-sql-database
10 |1000 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.

1 Answer

VaibhavChaudhari avatar image
0 Votes"
VaibhavChaudhari answered ·

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

·
10 |1000 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.