Import incremental data from Azure SQL database RRS feed

  • Question

  • I'm looking for the best (easiest) tool to regularly move incremental data from an Azure SQL database to my Azure SQL Data-warehouse. I've looked at Data Factory but that has limited options for updating records or only inserting new records, I'd rather not have to import ALL the data into staging tables, as the data volume will only increase over time. This would be for 20-30 tables so the easier the better.

    Any suggestions for better tools or other options I could use here?

    many thanks


    Tuesday, July 12, 2016 2:06 PM