i have 2 Azure SQL databases with around 30% data common between them. What are the options of syncing data between these 2 Azure SQL databases . Can the sync be instantenous ? Basically changes keep happening to both the databases and this has to be synced to the other database.
Not sure if Azure Data Sync is a good candidate for this or should we use something like Azure Functions or logic apps to synchronise data between the 2 databases.
or is azure datafactory a good option ?
Please help