Using Azure Pipelines to restore a production database to another environment
Often we need a fresh copy of the production database in another environment (eg DEV/TEST/UAT). Previously this was a tedious task involving getting a backup file, copying it to another location, restoring the database. Here is a solution to automate this process using Azure Pipelines. User Story Given a production database exists in subscription 1 When we do a release of the Azure Pipeline named ‘_Refresh Database – DEV’_ Then an copy of production is available in the DEV environment in subscription 2 And permissions are correct for the DEV environment Pipeline Overview For each environment that you wish to restore into create an Azure Pipeline with 3 stages. ...