- 首先你要安装好docker
- 下载一个kitematic docker 视图化工具,安装一下
然后去搜 sqlserver,安装一下 并启动
或者你手动去执行docker命令:
必须设置成强密码才行
sudo docker run -e 'ACCEPT_EULA=Y' -e 'MSSQL_SA_PASSWORD=QWER!123456' \
-p 1401:1433 --name sqlserver \
-d microsoft/mssql-server-linux:2017-latest
二、还原数据库
1、创建镜像sqlserver的文件目录
sudo docker exec -it sqlserver mkdir /var/opt/mssql/backup
2、拷贝文件
可以将bak文件放到用户主目录下面
sudo docker cp copyBak.bak sqlserver:/var/opt/mssql/backup
3、还原数据库
还原bak文件
sudo docker exec -it sqlserver /opt/mssql-tools/bin/sqlcmd -S localhost \
-U SA -P 'QWER!123456' \
-Q 'RESTORE FILELISTONLY FROM DISK = "/var/opt/mssql/backup/copyBak.bak"' \
| tr -s ' ' | cut -d ' ' -f 1-2
————————————————
出现下面的情况:
sudo docker exec -it sqlserver /opt/mssql-tools/bin/sqlcmd \
-S localhost -U SA -P 'QWER!123456' \
-Q 'RESTORE DATABASE copyBak FROM DISK = "/var/opt/mssql/backup/AKPWX.bak" WITH MOVE "SCM102SP2_Data" TO "/var/opt/mssql/data/copyBak.mdf", MOVE "SCM102SP2_log" TO "/var/opt/mssql/data/copyBak.ldf"'
出现这种情景,说明情况了,连接的mysql工具重新刷新下 数据库和表就出现了
连接sqlserver:
成功出来了!
修改密码:
sudo docker exec -it sqlserver /opt/mssql-tools/bin/sqlcmd \
-S localhost -U SA -P '1234qwer!' \
-Q 'ALTER LOGIN sa WITH PASSWORD="QWER!123456"'