oskaremil

oskaremil / add-test-server-with-user.sh

Created November 21, 2023 11:23

Docker MSSQL

	#!/bin/bash
	docker exec sql-server /opt/mssql-tools/bin/sqlcmd -U sa -P *** -Q "CREATE DATABASE TestDatabase"
	docker exec sql-server /opt/mssql-tools/bin/sqlcmd -U sa -P * -Q "CREATE LOGIN testuser WITH PASSWORD = '*'"
	docker exec sql-server /opt/mssql-tools/bin/sqlcmd -U sa -P *** -d TestDatabase -Q "CREATE USER testuser FOR LOGIN testuser"
	docker exec sql-server /opt/mssql-tools/bin/sqlcmd -U sa -P *** -d TestDatabase -Q "ALTER ROLE db_owner ADD MEMBER testuser"