Dev/test/staging environments for Azure SQL



Prerequisites

1. Production databases running in Azure SQL

2. Windocks installed on a VM which already has SQL Server. See this link for Windocks install details

3. BACPAC file of the Azure SQL database

Steps

Download the BACPAC file to the a storage that can be accessed by the machine running Windocks

Build the Windocks image - See the sample in windocks\samples\cloneFromBacpac. Build an image with the dockerfile below using the command
docker build -t yourimagename path\to\directory\containing\dockerfile
or by using the web application and selecting Build.

You may create dev/test/staging environments with cloned production data with Windocks. These environments (containers) are available on ports on the VM instance. You may specify the ports as well.

Users can use the Windocks web application to create the dev/test/staging environments with cloned production data from the image built above. More details on the web app are here

Alternatively, they can also use the REST API with curl to create and start the container with clone as documented here