Data incrementally update /Insert in azure sql db.

Question

Hi There,

I have a scenario like - We have an on-premise SQL database and Azure SQL database. On-premise, I have to pull data and place it in the Azure SQL database of around 20 tables. And This data should be incrementally updated/Insert in Azure SQL DB.

Can you guide me on how to do it in a better way?

Answer 1

You can use Azure Data Factory for that purpose. You can define a watermark column on the source tables as explained here. You can also use slicing as explained here.