Docker for mac创建sqlserver容器

1、创建系统卷挂载到docker上
docker create -v /Users/xxx/MicrosoftSQLServer:/var/opt/mssql --name sqlserver1433data mcr.microsoft.com/mssql/server:2017-latest
2、删除旧数据（如果有）
rm -rf /Users/xxx/MicrosoftSQLServer/.system
2、创建sqlserver容器
docker run -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=dev@123,' -p 1433:1433 --volumes-from sqlserver1433data --name sqlserver -it -d mcr.microsoft.com/mssql/server:2017-latest
3、检查model系统数据库
DBCC CHECKDB;
4、创建测试数据库
CREATE DATABASE [DB_TEST]
ON PRIMARY (NAME = N'DB_TEST', FILENAME = N'/var/opt/mssql/data/DB_TEST.mdf', SIZE = 8MB, MAXSIZE = UNLIMITED, FILEGROWTH = 64MB)
LOG ON (NAME = N'DB_TEST_log', FILENAME = N'/var/opt/mssql/data/DB_TEST_log.ldf', SIZE = 8MB, MAXSIZE = UNLIMITED, FILEGROWTH = 64MB )