Refresh DEV Azure SQL DB from PROD Azure DB backup

Question

Hi Team,

What is the procedure to Refresh DEV Azure SQL DB from PROD (Backup). We don't want to take a new DB backup. Only planning to use an available backup.

Answer 1

Hi @Vijay Kumar ,

Thanks for the ask and using Microsoft Q&A platform .

It seems that you have the requirement to keep on refreshing the data from production database to Development database in Azure SQL.

Adding to suggestion provided by @Vishal , we can use Azure SQL Data Sync to keep the database sync.

SQL Sync data offers the functionality to not only sync the Azure SQL Databases but if we are using the on-premise database it could also be synced. Also multiple databases can be configured if we have multiple environment. We can also schedule it run as per our requirement. Below is the screenshot of providing the sync frequency:

Another way to schedule it is through Azure Automation account. Please go through the below article for the same:

Schedule Data Sync with Azure SQL Database use an Automation account

Using SQL sync will help us in removing any manual effort in long term. I would also request you to go through the FAQs once to know any issues beforehand:

FAQ

Please do let us know if this helps or else we can discuss further on the same. If answer helps, you can mark it ''Accept Answer'.