Below is a command to start a container with port and volume mapping. Replace /Users/username/docker/mssql-data with the local path to use for the volume data
docker run \ –name mssql-test \ -d \ -e ‘ACCEPT_EULA=Y’ \ -e ‘SA_PASSWORD=StrongP@ssword!’ \ -e ‘MSSQL_PID=Express’ \ -p 1433:1433 \ -v /Users/username/docker/mssql-data:/var/opt/mssql \ microsoft/mssql-server-linux
CREATE DATABASE MyAppDB;
CREATE LOGIN app_user WITH PASSWORD = ‘TheStrongP@ssw0rd!’;
CREATE USER [app_user] FOR LOGIN [app_user];
EXEC sp_addrolemember N’db_owner’, N’app_user’
CREATE SCHEMA App;