MSSQL on docker 部署

1. MSSQL on docker 部署方式:
   微软官方文档
   在Docker上安装MSSQL(SQL Server)
2. 命令记录

docker pull microsoft/mssql-server-linux  
docker run --name MSSQL_1433 -m 512m -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=yourStrong(!)Password' -p 1433:1433 -d microsoft/mssql-server-linux  
#docker run --name MSSQL_1433 -m 512m -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=yourStrong(!)Password' --net=host -d microsoft/mssql-server-linux  
docker exec -it MSSQL_1433 /bin/bash  
/opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P 'yourStrong(!)Password'

3. docker容器的扩容

sudo docker -d --storage-opt dm.basesize=100G  

3. docker内启动jupyter

nohup jupyter notebook >/dev/null 2>&1 &  
docker run -it -p 8888:8888 --ipc=host ufoym/deepo:all-py36-jupyter-cpu   
nohup jupyter notebook --no-browser --ip=0.0.0.0 --allow-root --NotebookApp.token= --notebook-dir='/root'  >/dev/null 2>&1 &  

4. docker复制文件的方法
   docker 从容器复制文件到host 和 从宿主机复制到容器内
   首先，要用docker inspect方法获得容器的完整ID

docker inspect -f '{{.Id}}' master

这里的master可以是container name也可以是短的container ID。
然后，使用通道拷贝数据

cp /usr/java/jdk-7u75-linux-x64.rpm  /var/lib/docker/aufs/mnt/"id"/root/

5. 启动MSSQL

sudo docker exec -it sql1 /opt/mssql-tools/bin/sqlcmd -S localhost \
   -U SA -P '<YourNewStrong!Passw0rd>' \
   -Q 'RESTORE FILELISTONLY FROM DISK = "/var/opt/mssql/backup/wwi.bak"' \
   | tr -s ' ' | cut -d ' ' -f 1-2

LogicalName   PhysicalName
------------------------------------------
WWI_Primary   D:\Data\WideWorldImporters.mdf
WWI_UserData   D:\Data\WideWorldImporters_UserData.ndf
WWI_Log   E:\Log\WideWorldImporters.ldf
WWI_InMemory_Data_1   D:\Data\WideWorldImporters_InMemory_Data_1

调用RESTORE DATABASE命令在容器内的将数据库还原。 为每个文件上, 一步中指定新路径。

sudo docker exec -it sql1 /opt/mssql-tools/bin/sqlcmd \
   -S localhost -U SA -P '<YourNewStrong!Passw0rd>' \
   -Q 'RESTORE DATABASE WideWorldImporters FROM DISK = "/var/opt/mssql/backup/wwi.bak" WITH MOVE "WWI_Primary" TO "/var/opt/mssql/data/WideWorldImporters.mdf", MOVE "WWI_UserData" TO "/var/opt/mssql/data/WideWorldImporters_userdata.ndf", MOVE "WWI_Log" TO "/var/opt/mssql/data/WideWorldImporters.ldf", MOVE "WWI_InMemory_Data_1" TO "/var/opt/mssql/data/WideWorldImporters_InMemory_Data_1"'