June 16, 2015 at 9:35 pm
I'm trying to identify how to update data on an Azure SQL Data Warehouse from on-premises SQL by a nightly ETL process, but aren't sure if I'm following the recommended process.
Is the recommended procedure to use the Azure Data Factory Copy activity to upload one table at a time through a Data Gateway to an Azure blob and use something else to get that from the blob (file) into Azure SQL, as described in this Azure video (Introducing Azure Data Factory Copy Activity)[/url]?
This approach seems feasible, but would like confirmation whether it's sensible :).
June 17, 2015 at 8:45 am
SQL data sync services?
June 24, 2015 at 4:14 am
You could just use SSIS. It can connect to Azure SQL Database and you can move the data that way.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 20, 2015 at 7:35 pm
Brilliant - thanks for the replies. I've investigated using Azure Data Factory and Data Sync, but decided to implement a SSIS solution due to the service costs of Azure Data Factory and that I currently don't need a full database copy on Azure.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply