docker搭建SqlServer2019

docker部署sqlserver

1. 拉镜像

docker pull mcr.microsoft.com/mssql/server:2019-latest

2. 创建持久化目录

mkdir -p /home/pan/docker/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 12433:1433  \
-d --name sql-server2019 \
-v /home/pan/docker/sqlserver/data:/var/opt/mssql \
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