1. 拉镜像
docker pull mcr.microsoft.com/mssql/server:2019-latest
2. 创建持久化目录
mkdir /etc/sqlserver_data
chmod 777 /etc/sqlserver_data
3. 运行镜像
docker run -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=Ictsoft@123" -e "MSSQL_PID=Express" -p 1433:1433 --name sql-server2019 -v /root/lzy/sqlserver:/var/opt/mssql -d mcr.microsoft.com/mssql/server:2019-latest
4. 基本操作
登录数据库
/opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P "Ictsoft@123"
4.1 查看版本
Select @@version
GO
4.2 创建数据库
CREATE DATABASE TestDB;
SELECT Name from sys.databases;
GO
4.3 插入数据
USE TestDB;
CREATE TABLE dbo.Inventory (
id INT, name NVARCHAR(50),
quantity INT
);
INSERT INTO dbo.Inventory VALUES (1, 'banana', 150);
INSERT INTO dbo.Inventory VALUES (2, 'orange', 154);
GO