Home:ALL Converter>ETL / Replication from Azure SQL Database to on-premises SQL Server data warehouse

ETL / Replication from Azure SQL Database to on-premises SQL Server data warehouse

Ask Time:2021-02-06T14:44:00         Author:ydoow

Json Formatter

I'm trying to build daily ETL process from Azure SQL Database to on-premises SQL Server data warehouse.

I have experience in ETL between on-premises SQL Servers but when it comes to Azure I'm not sure the best practise. I did some researches and got the options on ETL and ADP.

Would anyone here have similar experience before, could shed me some lights? Any comment, example or tutorial are much appreciated.

Author:ydoow,eproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/66074276/etl-replication-from-azure-sql-database-to-on-premises-sql-server-data-warehou
yy