/exo-sqlserver

Docker image for sqlserver

Primary LanguageShell

SQL Server docker image by eXo Platform

This is a SQL Server image to easily build an SQL Server environment for test purposes with a dedicated database and user. It's build on top of the official Microsoft mssql image : https://hub.docker.com/r/microsoft/mssql-server-linux/

Versions

Version Microsoft base image Status
2017-CU8 microsoft/mssql-server-linux:2017-CU-8 Recommended
2017-CU7 microsoft/mssql-server-linux:2017-CU-7 Valid
2017-CU6 microsoft/mssql-server-linux:2017-CU-6 Valid
2017-CU5 microsoft/mssql-server-linux:2017-CU-5 Valid
2017-CU4 microsoft/mssql-server-linux:2017-CU-4 Valid
2017-CU3 microsoft/mssql-server-linux:2017-CU-3 Valid
2017-CU2 microsoft/mssql-server-linux:2017-CU-2 Valid
2017-CU1 microsoft/mssql-server-linux:2017-CU-1 Valid
2017-GA microsoft/mssql-server-linux:2017-GA Valid
ctp-2-1 microsoft/mssql-server-linux:ctp2-1 Deprecated
ctp-2 microsoft/mssql-server-linux:ctp2-0 Deprecated

Running

docker run -d -e SA_PASSWORD=<passord> -e SQLSERVER_DATABASE=<db name> -e SQLSERVER_USER=<user> -e SQLSERVER_PASSWORD=<password> -p <local port>:1433 exoplatform/sqlserver:2017-CU8

⚠️ For Docker4Mac and Docker4Windows users, your docker instance must have at least 3192Mo of memory allocated.

Supported environment variables :

  • SA_PASSWORD : The password of the SA user
  • SQLSERVER_DATABASE : the database name to use
  • SQLSERVER_USER : the username to use. It will be the owner of the database
  • SQLSERVER_PASSWORD : the password of the username

⚠️ All your password must match the MSSQL rule : at least 8 chars, with lower, upper and digits.

Ports :

  • 1433 : The database port

Volumes

The data is persisted on the directory /var/opt/mssql. Add the following option to persist your data on volume :

-v <your volume>:/var/opt/mssql