在CentOS上更新或升级SQL Server的步骤如下:
sudo yum update -y
添加安装源:
sudo curl -o /etc/yum.repos.d/mssql-server-2019.repo https://packages.microsoft.com/config/rhel/7/mssql-server-2019.repo
安装SQL Server软件包:
sudo yum install -y msodbcsql17 unixodbc-devel
初始化数据库:
sudo /opt/mssql/bin/mssql-conf setup
配置环境变量:
echo 'export PATH=/opt/mssql/bin:$PATH' >> ~/.bashrc
source ~/.bashrc
启动SQL Server服务:
sudo systemctl start mssql-server
设置SQL Server服务开机自启:
sudo systemctl enable mssql-server
检查服务状态:
sudo systemctl status mssql-server
连接到SQL Server:
sqlcmd -S localhost -U sa -P YourPassword
升级数据库:
ALTER DATABASE [YourDatabaseName] SET COMPATIBILITY_LEVEL 150; -- 150对应SQL Server 2022
验证升级结果:
DBCC CHECKDB ([YourDatabaseName])
sudo systemctl status mssql-server
sudo tail -f /var/log/mssql/errorlog
sudo firewall-cmd --zone public --add-port 1433/tcp --permanent
sudo firewall-cmd --reload
通过以上步骤,您可以在CentOS上成功更新和维护SQL Server。如果在操作过程中遇到问题,建议参考Microsoft的官方文档或联系技术支持获取帮助。