What's the data transfer process to update an Azure SQL Data Warehouse from On-Premises SQL?

  • 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 :).

  • SQL data sync services?

  • 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

  • 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