How to sync daily the prod database to dev database in Azure SQL Server service?
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)