RE: Azure SQL DB pulling from on-premises SQL Server via Data Gateway

Mr or Mrs. 500

Points: 558

January 10, 2018 at 2:35 am

#1975235

LittleKitten - Wednesday, January 10, 2018 2:16 AM
Have you tried using SSIS?
SSIS has a lot of Azure components and will do what you are asking quite easily.
Data Factory will as well, ,not sure about Flow as I have never used it.
You certainly have a choice
Natalie

Thank you LittleKitten, SSIS would have been my first choice, but I omitted that I was looking for something that didn't require to open many endpoints on the Azure SQL Database. I'm updating the original post.