centos7安装SQL server2019_centos安装sqlserver2019

centos7安装SQL server2019

1、yum安装

# 关闭防火墙
systemctl stop firewalld.service
systemctl disable firewalld.service
# 配置 yum 源
yum -y install wget
wget -O /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/7/mssql-server-2019.repo
yum clean all
yum makecache fast

# 安装 SQLserver
yum install mssql-server
# 初始化配置 SQLserver
/opt/mssql/bin/mssql-conf setup
1
2
3
4
5
6
7
8
9
10
11
12
13

2、启动 SQLserver

systemctl start mssql-server
systemctl enable mssql-server

# 验证
systemctl status mssql-server

# SQLserver 的安装路径在/var/opt/mssql，配置文件在 /var/opt/mssql/mssql.conf。
1
2
3
4
5
6
7

3、配置 SQLserver

mssql-conf是在Linux上安装SQL Server 2017后的一个配置脚本。使用命令 /opt/mssql/bin/mssql-conf 可以对 SQLserver 的配置进行修改优化。支持设置以下参数：

示例1：启用 SQLServer 代理

/opt/mssql/bin/mssql-conf set sqlagent.enabled true

# 需要重启
systemctl restart mssql-server
1
2
3
4
5

示例2：修改默认数据和日志目录位置

filelocation.defaultdatadir和filelocation.defaultlogdir 设置修改新的数据和日志文件创建的位置。默认路径是：/var/opt/mssql/data。修改到：/home/msdata，操作如下：

mkdir -p /home/mssql/data
mkdir -p  /home/mssql/log
chown -R mssql:mssql /home/mssql

# 使用mssql-conf脚本执行set命令修改默认数据目录
/opt/mssql/bin/mssql-conf set filelocation.defaultdatadir /home/mssql/data
# 修改日志目录
/opt/mssql/bin/mssql-conf set filelocation.defaultlogdir /home/mssql/log

# 需要重启
systemctl restart mssql-server
1
2
3
4
5
6
7
8
9
10
11
12

4、docker方式安装

docker run -d -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=abc123!@#" -p 1433:1433 -v mssql:/var/opt/mssql --name mssql --hostname mssql -d mcr.microsoft.com/mssql/server
1

5、安装 SQLserver 客户端 sqlcmd

yum install -y mssql-tools unixODBC-devel

echo "export PATH=$PATH:/opt/mssql-tools/bin" >> /etc/profile
source /etc/profile

# 连接 SQLserver
sqlcmd -S <SQLserver_IP> -U SA -p
1
2
3
4
5
6
7

6、新建数据库

CREATE DATABASE erpdata
ON PRIMARY
(
    NAME = 'MyDatabase_data',
    FILENAME = '/var/opt/mssql/data/erpdata_data.mdf',
    SIZE = 64MB,
    MAXSIZE = 4GB,
    FILEGROWTH = 10%
)
LOG ON
(
    NAME = 'MyDatabase_log',
    FILENAME = '/var/opt/mssql/data/erpdata_log.ldf',
    SIZE = 32MB,
    MAXSIZE = 1GB,
    FILEGROWTH = 500MB
);
GO
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19