azureazure-sql-databaseazure-data-sync

Data transfer in Azure SQL database


I have 2 web application that the databases are azure sql.

  1. 1st web is used to record all payment and internal business rule
  2. 2nd web is used to capture request payment from external vendor

I'm planning to transfer data between both databases and there will be job execution for some interval time.

Usually, I use SSIS but in this case all databases are in the cloud environment. I don't have any idea:

please, tell me a brief simplest process to do data transfer in Azure (reference/link/keyword), then I will explore by myself.


Solution

  • You used the word "synchronizing" if you are looking to transfer data between the 2 databases to keep them synchronize then you should consider using Azure SQL Data Sync to synchronize group of tables between databases with a sync frequency of seconds, minutes, hours, or days.

    For incremental data load you can consider using slices in Azure Data Factory (ADF) as explained here. With ADF you can use a watermark column for incremental loading