Mac OS Ubuntu虚拟机安装SQL Server 2019

在安装之前，首先确保Ubuntu的安装镜像源已经更换至任意一个国内镜像源，这里我使用清华的镜像。

寻找更新镜像源

备份 Ubuntu 默认的源地址

sudo cp /etc/apt/sources.list /etc/apt/sources.list.backup

更新源服务器列表

sudo vim /etc/apt/sources.list

安装 SQL Server

wget -qO- https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -

sudo add-apt-repository "$(wget -qO- https://packages.microsoft.com/config/ubuntu/18.04/mssql-server-2019.list)"

注意：这里不需要更换 ubuntu/20.04/ ，仍然使用 ubuntu/18.04/即可。

sudo apt-get update
sudo apt-get install -y mssql-server

renyimeng@renyimeng-virtual-machine:~$ sudo /opt/mssql/bin/mssql-conf setup
Choose an edition of SQL Server:
  1) Evaluation (free, no production use rights, 180-day limit)
  2) Developer (free, no production use rights)
  3) Express (free)
  4) Web (PAID)
  5) Standard (PAID)
  6) Enterprise (PAID)
  7) Enterprise Core (PAID)
  8) I bought a license through a retail sales channel and have a product key to enter.

Details about editions can be found at
https://go.microsoft.com/fwlink/?LinkId=852748&clcid=0x409

Use of PAID editions of this software requires separate licensing through a
Microsoft Volume Licensing program.
By choosing a PAID edition, you are verifying that you have the appropriate
number of licenses in place to install and run this software.

Enter your edition(1-8): 2
The license terms for this product can be found in
/usr/share/doc/mssql-server or downloaded from:
https://go.microsoft.com/fwlink/?LinkId=855862&clcid=0x409

The privacy statement can be viewed at:
https://go.microsoft.com/fwlink/?LinkId=853010&clcid=0x409

Do you accept the license terms? [Yes/No]:Yes

Enter the SQL Server system administrator password:  <SetStrongNewPassword>
Confirm the SQL Server system administrator password: <ConfirmStrongPassword>
Configuring SQL Server...

ForceFlush is enabled for this instance. 
ForceFlush feature is enabled for log durability.
Created symlink /etc/systemd/system/multi-user.target.wants/mssql-server.service → /lib/systemd/system/mssql-server.service.
Setup has completed successfully. SQL Server is now starting.

注意：SA密码设置规则最少 8 个字符，包括大写和小写字母、十进制数字和/或非字母数字符号。

systemctl status mssql-server --no-pager

安装 SQL Server 命令行工具

若要创建数据库，则需要使用可在 SQL Server 上运行 Transact-SQL 语句的工具进行连接。以下步骤将安装 SQL Server 命令行工具：sqlcmd 和 bcp。

通过以下步骤在 Ubuntu 上安装 mssql-tools 和 **unixODBC **插件：

curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -
curl https://packages.microsoft.com/config/ubuntu/20.04/prod.list > /etc/apt/sources.list.d/mssql-release.list
sudo apt update 
sudo ACCEPT_EULA=Y apt install mssql-tools unixodbc-dev

配置 SQL 环境 (optional)

要使 sqlcmd/bcp 能从登陆会话的 bash shell 进行访问，请使用下列命令修改 ~/.bash_profile 文件中的 PATH ：

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

要使 sqlcmd/bcp 能从交互式/非登录会话的 bash shell 进行访问，请使用下列命令修改 ~/.bashrc 文件中的 PATH ：

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

连接 MS SQL 控制台

sqlcmd -S 127.0.0.1 -U SA

新建数据库

1> create database testDB;

2> select name from sys.databases;

TPCH 数据库创建

创建 TPCH 数据库

在 tpch 数据库中创建相应的表

SELECT
  *
FROM
  INFORMATION_SCHEMA.TABLES;
GO

加载服务器的数据到数据库中

head -10 new_region.tbl  # 查看文件前2行

使用命令将已经去除行末竖线的数据加载到数据库TPCH中，并创建相应的表：

更换安装镜像源