SQL Server 2017 on Linux自动安装

SQL Server 2017在Linux平台安装虽然很简单，只要按照指令一行一行贴上就可以完成，但懒人总是想着更快的方法，于是找了官方文件发现竟然有自动安装的范例，测试一下果真OK。

请参阅以Red Hat Enterprise Linux为例，利用vi指令在Linux内建一个档案例如installsql.sh，然后将范例指令码贴上

预设只会安装database engine，SQL Server 命令列工具，SQL Server Agent

#!/bin/bash# Use the following variables to control your install:# Password for the SA user (required)MSSQL_SA_PASSWORD='<YourStrong!Passw0rd>'# Product ID of the version of SQL server you're installing# Must be evaluation, developer, express, web, standard, enterprise, or your 25 digit product key# Defaults to developerMSSQL_PID='evaluation'# Install SQL Server Agent (recommended)SQL_INSTALL_AGENT='y'# Install SQL Server Full Text Search (optional)# SQL_INSTALL_FULLTEXT='y'# Create an additional user with sysadmin privileges (optional)# SQL_INSTALL_USER='<Username>'# SQL_INSTALL_USER_PASSWORD='<YourStrong!Passw0rd>'if [ -z $MSSQL_SA_PASSWORD ]then  echo Environment variable MSSQL_SA_PASSWORD must be set for unattended install  exit 1fiecho Adding Microsoft repositories...sudo curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/7/mssql-server-2017.reposudo curl -o /etc/yum.repos.d/msprod.repo https://packages.microsoft.com/config/rhel/7/prod.repoecho Installing SQL Server...sudo yum install -y mssql-serverecho Running mssql-conf setup...sudo MSSQL_SA_PASSWORD=$MSSQL_SA_PASSWORD \     MSSQL_PID=$MSSQL_PID \     /opt/mssql/bin/mssql-conf -n setup accept-eulaecho Installing mssql-tools and unixODBC developer...sudo ACCEPT_EULA=Y yum install -y mssql-tools unixODBC-devel# Add SQL Server tools to the path by default:echo Adding SQL Server tools to your path...echo PATH="$PATH:/opt/mssql-tools/bin" >> ~/.bash_profileecho 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrcsource ~/.bashrc# Optional SQL Server Agent installation:if [ ! -z $SQL_INSTALL_AGENT ]then  echo Installing SQL Server Agent...  sudo yum install -y mssql-server-agentfi# Optional SQL Server Full Text Search installation:if [ ! -z $SQL_INSTALL_FULLTEXT ]then    echo Installing SQL Server Full-Text Search...    sudo yum install -y mssql-server-ftsfi# Configure firewall to allow TCP port 1433:echo Configuring firewall to allow traffic on port 1433...sudo firewall-cmd --zone=public --add-port=1433/tcp --permanentsudo firewall-cmd --reload# Example of setting post-installation configuration options# Set trace flags 1204 and 1222 for deadlock tracing:#echo Setting trace flags...#sudo /opt/mssql/bin/mssql-conf traceflag 1204 1222 on# Restart SQL Server after making configuration changes:echo Restarting SQL Server...sudo systemctl restart mssql-server# Connect to server and get the version:counter=1errstatus=1while [ $counter -le 5 ] && [ $errstatus = 1 ]do  echo Waiting for SQL Server to start...  sleep 5s  /opt/mssql-tools/bin/sqlcmd \    -S localhost \    -U SA \    -P $MSSQL_SA_PASSWORD \    -Q "SELECT @@VERSION" 2>/dev/null  errstatus=$?  ((counter++))done# Display error if connection failed:if [ $errstatus = 1 ]then  echo Cannot connect to SQL Server, installation aborted  exit $errstatusfi# Optional new user creation:if [ ! -z $SQL_INSTALL_USER ] && [ ! -z $SQL_INSTALL_USER_PASSWORD ]then  echo Creating user $SQL_INSTALL_USER  /opt/mssql-tools/bin/sqlcmd \    -S localhost \    -U SA \    -P $MSSQL_SA_PASSWORD \    -Q "CREATE LOGIN [$SQL_INSTALL_USER] WITH PASSWORD=N'$SQL_INSTALL_USER_PASSWORD', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=ON, CHECK_POLICY=ON; ALTER SERVER ROLE [sysadmin] ADD MEMBER [$SQL_INSTALL_USER]"fiecho Done!

要修改的参数只有1个，修改SA的密码

# Password for the SA user (required)MSSQL_SA_PASSWORD='<YourStrong!Passw0rd>'

以下为可以调整的选项

安装的版本预设是试用版

# Defaults to developerMSSQL_PID='evaluation'

可以改为以下7种选项

如果要安装全文检索，请移除#

# Install SQL Server Full Text Search (optional)# SQL_INSTALL_FULLTEXT='y'

如果要建立另一个具有sysadmin权限使用者请移除#后输入使用者名称及密码

# Create an additional user with sysadmin privileges (optional)# SQL_INSTALL_USER='<Username>'# SQL_INSTALL_USER_PASSWORD='<YourStrong!Passw0rd>'

如果要开启追踪dead lock请移除#

# Example of setting post-installation configuration options# Set trace flags 1204 and 1222 for deadlock tracing:#echo Setting trace flags...#sudo /opt/mssql/bin/mssql-conf traceflag 1204 1222 on

实测后有段指令少了，要让sqlcmd/bcp bash壳层互动式/非登入工作阶段，少了第2行指令

echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrcsource ~/.bashrc

存档离开vi后，将档案修改为可执行

chmod +x installsql.sh

然后执行即可

./installsql.sh

本文翻译自：dotblogs.com.tw 潜水太久总要浮出水面的