How to sync daily the prod database to dev database in Azure SQL Server service? I have two Azure SQL Database, prod and dev.
How can i daily replicate the prod database into dev database?
I have tried to automate it by exporting and importing the BACPAC file but it takes too long time.
There is Data Sync service in Azure but I am not sure if it works in one direction.
Do you have any suggestions?
You can try &quot;Geo-replication&quot;
Go to your prod &quot;SQL Database&quot;, Settings &gt; Geo-replication
Configure your dev server/database to be readable &quot;secondary&quot;
All changes made at prod database , will be applied to dev database right away
Beware that you won't be able to change (insert,update,delete,create,etc) data at dev database while it is in the &quot;readable secondary&quot; role - only read (select)