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

webquake/mssql

Dockerfile for MS-SQL Server 2019 and a setup script. The script /usr/src/app/setup.sql cretates a new database supplied in the environment variable DATABASE:

• DATABASE={Database-Name}
• MSSQL_AGENT_ENABLED={True}
• MSSQL_SA_PASSWORD={password}
• ACCEPT_EULA={Y}
• MSSQL_PID={Developer}

docker build --progress=plain --no-cache -t webquake/mssql .
docker run -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=myPassword" -e "DATABASE=myDatabase" -p 1433:1433 webquake/mssql

setup.sql:

DECLARE @dbname nvarchar(128)
SET @dbname = N'###Database###'
PRINT 'Check for database ' + @dbname
IF NOT(EXISTS (SELECT name FROM sys.databases WHERE ('[' + name + ']' = @dbname OR name = @dbname)))
BEGIN
    EXEC('CREATE DATABASE '+ @dbname)
END