一、下载镜像
docker pull microsoft/mssql-server-linux
二、启动容器
docker-compose
version: '3'
services:
sqlserver:
image: microsoft/mssql-server-linux:latest
restart: always
privileged: true
container_name: sqlserver
ports:
- 1433:1433
volumes:
- ./data:/var/opt/mssql/data
environment:
ACCEPT_EULA: Y
SA_PASSWORD: aA123456
# 启动
docker-compose up -d && docker logs -f sqlserver
验证是否成功
-- 进入容器
docker exec -it sqlserver /opt/mssql-tools/bin/sqlcmd -S localhost -U sa
-- 查询版本
SELECT @@VERSION
go
-- 查询所有数据库
SELECT Name FROM Master..SysDatabases ORDER BY