SQLServer

Subsections of SQLServer

How to create DB

Modify following script without your user/db/password

CREATE DATABASE database;
GO
USE database;
GO
CREATE LOGIN username WITH PASSWORD = 'password';
GO
CREATE USER username FOR LOGIN username;
GO

script can be run as:

/opt/mssql-tools/bin/sqlcmd -S "hostname,1433" -U SA -P SA_PASSWORD -i /sqlserver-init.sql;