luksi1/mssql Docker 镜像 - 轩辕镜像 | Docker 镜像高效稳定拉取服务

Description

The default MS SQL image does not support running scripts on start, even if this is a more or less de facto way of producing Docker database images. This image attempts to bring the MS SQL image up to snuff.

Additionally, there is support for a database user and database via environmental variables.

Source code

All source files can be found on GitHub here.

Usage

Environment variables

This image provides the same environment variables as the parent image with the addition of a MSSQL_USER, MSSQL_PASSWORD, and MSSQL_DATABASE account

MSSQL_USER

A SQL user that will get DBO access on MSSQL_DATABASE

MSSQL_PASSWORD

The password for MSSQL_USER

MSSQL_DATABASE

A SQL database this will be created on start. MSSQL_USER will have DBO access to this database.

MSSQL_SA_PASSWORD

The sysdba password for the instance.

Examples

Command line

docker run --rm -e MSSQL_USER=TEST -e MSSQL_PASSWORD=Abcd1234 -e MSSQL_SA_PASSWORD=Abcd1234 -e MSSQL_DATABASE=test -t luksi1/mssql:latest

docker-maven-plugin

Note: Notice the use of a portPropertyFile so that you can obtain the random port allocated to MSSQL in your flow!

<image>
    <name>luksi1/mssql:latest</name>
    <run>
            <portPropertyFile>/tmp/mssql.port.properties</portPropertyFile>
            <env>
                    <MSSQL_USER>test</MSSQL_USER>
                    <MSSQL_PASSWORD>Abcd1234</MSSQL_PASSWORD>
                    <MSSQL_SA_PASSWORD>Abcd1234</MSSQL_SA_PASSWORD>
                    <MSSQL_DATABASE>test</MSSQL_DATABASE>
            </env>
            <wait>
                    <time>60000</time>
            </wait>
            <ports>
                    <port>database.random.port:${database.port}</port>
           </ports>
    </run>
 </image>

Original image

You can find the original MS SQL Docker image, from which this image is derived, here:

[***]