说明:配置MSSQL数据库Docker容器
1. docker-compose.yml
mssql:
image: "mcr.microsoft.com/mssql/server:2019-latest"
container_name: ${APP_NAME:?err}-mssql
restart: always
ports:
- "1433:1433"
environment:
SA_PASSWORD: "your password"
ACCEPT_EULA: "Y"
MSSQL_AGENT_ENABLED: "True" # 启用mssql agent, 虽然没什么用
volumes:
- "/data0/Server/Db/mssql:/var/opt/mssql/data" # 映射数据文件夹连接
- "/data0/Server/Logs/mssql:/var/opt/mssql/log" # 映射日志路径
2. 数据库导入
碰过的坑:用navicat导mssql数据库存在比较大的问题,各种错误,如RowVersion/ timestamp类型的数据列导出不了
解决方案:
- 用Sql Server Management Studio 先备份出源数据库文件,如db1.bak
- 拷贝db1.bak到/data0/Server/Db/mssql,再还原