question

MSTechie-7364 avatar image
0 Votes"
MSTechie-7364 asked AlbertoMorillo commented

Syching few tables across Azure SQL tables

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

azure-data-factoryazure-sql-database
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

AlbertoMorillo avatar image
0 Votes"
AlbertoMorillo answered AlbertoMorillo commented

SQL Data Sync may be your first option which has Automatic Sync. If you choose to enable it (set it on), you enter a number and select Seconds, Minutes, Hours, or Days in the Sync Frequency section. The first sync begins after the selected interval period elapses from the time the configuration is saved.

The first sync may take a while because it is a row by row comparison. Some other factors have an influence on the duration of the initial sync like: service tier and size of the databases/tables. If one of the table has data and the other not, then the initial sync is faster.

In addition, you can use Azure Data Factory with an hourly interval to sync, here you will find a good example.

Another option is to use Cross-Database queries as mentioned here, and schedule execution of synchronization procedure created by yourself using elastic jobs or Azure Automation.


· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Can we sync only few tables across Azure SQL DB PaaS

0 Votes 0 ·

Yes. Please see an example of how to select tables for the synch on this article


1 Vote 1 ·