https://mcr.microsoft.com/en-us/product/mssql/server/
docker run -d --name mssql --hostname mssql --restart=always --network mgr --ip 172.18.0.243 --privileged=true -e TZ='Asia/Shanghai' -e LANG='zh_CN.UTF-8' --ulimit nofile=262144:262144 -e "ACCEPT_EULA=Y" -e "SA_PASSWORD='wdqdmm@m'" -v /data/site/docker/data/mssql:/var/opt/mssql/data -p 1433:1433 mcr.microsoft.com/mssql/server
-SQL Server Management Studio (SSMS)
登录名: sa
加密: 强制
docker exec -it mssql /bin/bash
-查看版本
Select @@version
-创建数据库
CREATE DATABASE TestDB;
SELECT Name from sys.databases;
-p 1433:1433
mcr.microsoft.com/mssql/server:2022-latest
-
mcr.microsoft.com/mssql/server:2019-latest
-e "MSSQL_SA_PASSWORD=Ictsoft@123" -e "MSSQL_PID=Express"
docker exec -it mssql /opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P 'wdqdmm@m'
签名:这个人很懒,什么也没有留下!