I would like to know if and how I could import into an Azure SQL Database pulling data from an on-premises SQL Server via a Microsoft Data Gateway.
Do I need to use something like Microsoft Flow or Azure Data Factory?
Thanks in advance
I'll need to feed the Azure Database from many different on-premises SQL Databases from different customers, whose IPs could possibly change over time and in non-predictable ways (switching over backup connections, changes of infrastructure, etc).
Hence in the Azure SQL Database configuration, I could not register all the possible IPs.
So I am looking for a solution to *pull* data more than to *push* it.