Share via

SQL to Azure DW sync

Alexey Chusov 1 Reputation point
2021-05-28T08:13:41.54+00:00

Hi,
I am not very technical, apologies in advance.
We have an SQL database called Global hosted in Azure tenant, it contains 3000 tables.
We've uploaded only 30 of those tables with all historical data into our newly established Synapse DW (full load).
From then on Synapse DW was synced with the Global daily through a full load (several times a day).
We'd like to explore a possibility of uploading data incrementally instead in order to optimize the performance and cost.
How do we go about it?

Azure SQL Database

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Oury Ba-MSFT 20,716 Reputation points Microsoft Employee
    2021-06-01T19:39:20.643+00:00

    Hello @Alexey Chusov If you want to use ADF then this tutorial Incrementally copy multiple tables using Azure portal -Azure Data Factory | Microsoft Learn will be very helpful. Please go through step by step and let us know if you still need further assistance.
    Regards,
    Oury

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.