Docker-mssql

https://hub.docker.com/r/kkarczmarczyk/mssql/

Microsoft SQL Server docker image with .sql startup file, based on official microsoft/mssql-server image

Supported tags and respective Dockerfile links

• latest (latest/Dockerfile) - the latest CU of the latest GA release

Environment Variables

• SA_PASSWORD (optional) - is the database system administrator (userid = 'sa') password used to connect to SQL Server once the container is running. Important note: This password needs to include at least 8 characters of at least three of these four categories: uppercase letters, lowercase letters, numbers and non-alphanumeric symbols. (Default: SuperSecret!)

• MSSQL_DB database name (will be created at startup)

• MSSQL_USER username for MSSQL_DB

• MSSQL_PASSWORD password for MSSQL_USER

• MSSQL_PID (optional) - is the Product ID (PID) or Edition that the container will run with. Acceptable values:

  • Developer : This will run the container using the Developer Edition (this is the default if no MSSQL_PID environment variable is supplied)
  • Express : This will run the container using the Express Edition
  • Standard : This will run the container using the Standard Edition
  • Enterprise : This will run the container using the Enterprise Edition
  • EnterpriseCore : This will run the container using the Enterprise Edition Core

Additional startup .sql script

You can execute additional .sql file for database from outside of container at database startup. This container exposes volume /usr/sql - if you link this volume with local folder which contains query.sql file, queries inside file will be executed.

Docker compose

This is an example docker-compose.yaml file:

version: '2'
services:

  mssqldev:
    container_name: mssqldev
    image: kkarczmarczyk/mssql
    ports:
      - "1433:1433"
    environment:
      MSSQL_DB: devdb
      MSSQL_USER: dev
      MSSQL_PASSWORD: randompassword
    volumes:
    - ./{folder with query.sql file}:/usr/sql

Misc

This image is inspired by:

• https://github.com/mcmoe/mssqldocker/blob/master/Dockerfile
• https://github.com/Microsoft/sql-server-samples/tree/master/samples/containers/replication/db2
• https://github.com/twright-msft/mssql-node-docker-demo-app

Note: By using this container, you accept SQL Server EULA. Go to https://hub.docker.com/r/microsoft/mssql-server/ for more details.