MSSQL Reference - Docker Container and Install AdventureWorks database

mssql-docker-adventureworks.sh

# 1. Run the MSSQL container on the Docker:
docker run -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=<YourStrong!Passw0rd>" --name "sql" -p 1433:1433 -v sqldata:/var/opt/mssql -d mcr.microsoft.com/mssql/server:2017-latest

# 2. Restore AdventureWorks2017 database:

# create the backup folder on data volume container
docker exec -it sql mkdir /var/opt/mssql/backup

# download the AdventureWorks file
curl -OutFile "AdventureWorks2017.bak" "https://github.com/Microsoft/sql-server-samples/releases/download/adventureworks/AdventureWorks2017.bak"

# copy the AdventureWorks file into the backup folder
docker cp AdventureWorks2017.bak sql:/var/opt/mssql/backup