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/
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 |
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
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
- 1433 : The database port
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