linux安装sqlserver

刚踩完坑，马上过来记下！！！

wget -qO- https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -
add-apt-repository “$(wget -qO- https://packages.microsoft.com/config/ubuntu/16.04/mssql-server-2017.list)”
apt-get update
apt-get install -y mssql-server
apt-get -f install
sudo /opt/mssql/bin/mssql-conf setup
systemctl stop mssql-server
sudo /opt/mssql/bin/mssql-conf set-collation
Chinese_PRC_CI_AS
systemctl enable mssql-server && systemctl start mssql-server

到这里就安装完啦！！！
接下来使用navicat连接sqlserver
通过sql语句建一个库

USE [master]
GO

/****** Object: Database [meihua] Script Date: 2022/1/10 19:44:49 ******/
CREATE DATABASE [meihua_test]
CONTAINMENT = NONE
ON PRIMARY
( NAME = N’meihua’, FILENAME = N’/var/opt/mssql/data/meihua.ndf’ , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB )