Sign inSign up

webquake/mssql

By webquake

•Updated almost 2 years ago

MS-SQL-Server with fulltext, tools and database creation script

Image
0

1.5K

webquake/mssql repository overview

⁠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

Tag summary

Content type

Image

Digest

sha256:023a80e4f…

Size

782 MB

Last updated

almost 2 years ago

docker pull webquake/mssql