Automating Nightly Local Database Refreshes from Azure Blob Storage with Docker

• AzureAutomation

  1 1 3.8 PowerShell

This article assumes that you have already set up an automation to back up your production database to Azure Blob Storage. If you have not done this, you can follow the instructions in this article: Automating Nightly Database Backups to Azure Blob Storage. The script in the article is reaching end of life, and an updated version can be found here.

• az-bacpac-blob-mssql-importer

  1 0 3.8 Shell

  This Docker container is designed to automatically download the latest database backup in a `bacpac` format from an Azure Blob Storage container and import it into the included local, dockerized MSSQL Server instance.

The code for this solution is available on GitHub. This docker container is also available on Docker Hub.

• Scout Monitoring

  www.scoutapm.com featured

  Free Django app performance insights with Scout Monitoring. Get Scout setup in minutes, and let us sweat the small stuff. A couple lines in settings.py is all you need to start monitoring your apps. Sign up for our free tier today.

  

• jmespath.py

  30 2,103 0.0 Python

  JMESPath is a query language for JSON.

  

The Azure CLI lets us write queries to filter the results of the az storage blob list command. The queries are written in JMESPath, which is a query language for JSON. In this case, we are filtering the results to only include blobs that end with the .bacpac extension and then selecting the first one as ordered by the lastModified property. If there are no blobs found, the script exits with a failure code. If we find a blob, we download it to the local path specified by the localPath variable.

Suggest a related project