CODEWITHSUNDEEP
sql-serverazureazure-sql-databaseazure-data-sync
wooters
wooters

Reputation: 977

Syncing two Azure databases without using Azure Data Sync

I have a huge (500+ table) Azure SQL database (SQL Server). I need to create a clone of this database on Azure, and sync the two databases once daily. The clone is for reporting purposes.

What is the best way to implement the sync, outside of Azure Data Sync? We've experimented with Azure Data Sync, and it's proven unreliable due to the large size of the database.

I've looked into transactional replication, but I cannot find any documentation that states that it is supported from an Azure database to another Azure database. Geo-replication may be another option, though I'm not sure it is a good fit for this use case.

Upvotes: 2

Views: 2112

Answers (1)

Alberto Morillo
Alberto Morillo

Reputation: 15658

To my knowledge, your best option is Azure Data Factory. It has a very easy to use Wizard as explained here. You can create yourself your copy activities as explained here and here.

You can schedule ADF execution as explained here too.

SQL Data Sync is in Preview and for that reason not recommended for Production environment.

Geo-Replication cannot scheduled for synchronization.

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.

Hope this helps.

Upvotes: 1

Related Questions