For the use of pretty much everything, my team has a pretty dedicated Azure SQL.
However, we use Azure Postgres for our web application (which is a Django app running on Linux App Service).
Typically, the data engineers only work with the Azure SQL DB. What is the best method for transferring data in real time from a Postgres database to an Azure SQL database?
The only alternative I can think of right now is to use an Azure Data Factory Copy Activity to perform the copy job. Evidently, though, it's not in real time.
Thank you!