I'm trying to achieve live (instantaneous) data synchronization between two SQL databases [3 source tables to 1 target table], the synchronized data come from 3 different tables in the source database and should go into one table. I have looked into some options and had those disadvantages:
1 - Azure Data Sync: a- 5 minute intervals of synchronization b- Synchronization between tables happen on a 1 to 1 bases.
2 - Azure Logic App: a - SQL connector throttling issues
Is there a better way to achieve this?
https://stackoverflow.com/questions/66957856/sql-databases-live-synchronization April 06, 2021 at 02:25AM
没有评论:
发表评论