I have 2 web application that the databases are azure sql.
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.
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