ajinnov/mssql-server-linux-dev repository overview

⁠Docker SQL Server for Dev

This image allows you to quickly start a SQL Server 2017 server in Docker for the testing needs of development teams. It uses Google Cloud Storage to retrieve SQL files to create tables and databases.

⁠Quickstart

To start you're gonna need:

• A Google Cloud project
• A Google Cloud service account key
• A GCS bucket
• Your .sql files

1. Create a file named .env containing the required env variables :

touch .env

Example of .env file :

MSSQLDEV_GOOGLE_PROJECT_NAME=myproject
MSSQLDEV_GCP_SA_EMAIL=myserviceaccount@myproject.iam.gserviceaccount.com
MSSQLDEV_GCP_SA_KEY_PATH=/home/mssql/secrets

ACCEPT_EULA=Y
SA_PASSWORD=MyStrongPassword@

1. Make sure your designated bucket file tree is like :

- databases
-- my_db_1_.sql
- tables
-- my_table_1.sql

1. You can either build this image

docker build . -t ajinnov/mssql-server-linux-dev:release-1.0.0

... or use the public build :

https://hub.docker.com/r/ajinnov/mssql-server-linux-dev⁠

ajinnov/mssql-server-linux-dev:release-1.0.0

1. And run it ...

docker run -d -v $(pwd)/secrets:/home/mssql/secrets -v mssql_for_dev_data:/var/opt/mssql \
--env-file=$(pwd)/.env \
 --name sql1 -p 1434:1433 \
 ajinnov/mssql-server-linux-dev:release-1.0.0

If you want to update your database, simply add the files in your bucket and run

docker exec -it MY_CONTAINER_NAME /home/mssql/update_sql_from_gcs.sh

⁠Acknowledgements

This image is based on mcr.microsoft.com/mssql/server:2017-latest