Download, install. configure and run Microsoft SQL-Server in less than one minute using Docker

mssql.sh

#!/bin/bash

echo '[+] Stop running mssql'
docker container rm -f mssql &>/dev/null

echo '[+] Remove Docker image'
docker image rm mcr.microsoft.com/mssql/server:2019-latest &>/dev/null

echo "[+] Start time $(date +%R:%S)"
START=$(date +%s)
echo '[+] Download image from Docker hub (1.55GB)'
docker pull mcr.microsoft.com/mssql/server:2019-latest &>/dev/null


echo '[+] Start new mssql'
docker container run --name mssql --rm -d -e 'TZ=Europe/Copenhagen' -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=godt_hemmeligt_k0de0Rd" -p 1433:1433 mcr.microsoft.com/mssql/server:2019-latest &>/dev/null

echo '[+] Wait 20 seconds for the database to be ready'
sleep 20

echo '[+] Connect to database and run some SQL'
echo 'SELECT 2+2'
echo 'SELECT current_timestamp'
docker exec -i mssql /opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P 'godt_hemmeligt_k0de0Rd' << EOT
SELECT 2+2;
GO

SELECT current_timestamp;
GO

EXIT
EOT
echo "[+] End time $(date +%R:%S)"
END=$(date +%s)
date +%R:%S
echo "Time used: $((END-START)) seconds"

[+] Stop running mssql
[+] Remove Docker image
[+] Start time 15:11:59
[+] Download image from Docker hub (1.55GB)
[+] Start new mssql
[+] Wait 20 seconds for the database to be ready
[+] Connect to database and run some SQL
SELECT 2+2
SELECT current_timestamp
           
-----------
          4

(1 rows affected)
                       
-----------------------
2022-01-04 15:12:58.677

(1 rows affected)
Time used: 59 seconds