Docker MSSQL 添加读取 MDF 文件

创建容器

sudo docker run -d -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=Password@123456" --name=mssql -v "`pwd`":/var/opt/db mcr.microsoft.com/mssql/server:2017-latest

进入容器，连接数据库

/opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P Password@123456

添加MDF

1> USE [master]
2> GO
1>create database [dbname] on (FILENAME=N'/var/opt/db/dbname.mdf'),(FILENAME=N'/var/opt/db/dbname_log.ldf') for ATTACH_REBUILD_LOG
2>GO
1> SELECT name FROM master.dbo.sysdatabases
2> GO