Ubuntu 下部署 SQL Server 2017

$ curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -

$ add-apt-repository "$(curl https://packages.microsoft.com/config/ubuntu/16.04/mssql-server-2017.list)"

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

$ /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): 1
The license terms for this product can be found in
/usr/share/doc/mssql-server or downloaded from:
https://go.microsoft.com/fwlink/?LinkId=855864&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:
Confirm the SQL Server system administrator password:
Configuring SQL Server...

The licensing PID was successfully processed. The new edition is [Enterprise Evaluation Edition].
Created symlink from /etc/systemd/system/multi-user.target.wants/mssql-server.service to /lib/systemd/system/mssql-server.service.
Setup has completed successfully. SQL Server is now starting.

$ systemctl status mssql-server

● mssql-server.service - Microsoft SQL Server Database Engine
   Loaded: loaded (/lib/systemd/system/mssql-server.service; enabled; vendor preset: enabled)
   Active: active (running) since Thu 2017-10-12 11:50:29 CST; 1min 22s ago
     Docs: https://docs.microsoft.com/en-us/sql/linux
 Main PID: 20776 (sqlservr)
   CGroup: /system.slice/mssql-server.service
           ├─20776 /opt/mssql/bin/sqlservr
           └─20796 /opt/mssql/bin/sqlservr

$ curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -

$ add-apt-repository "$(curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list)"

$ apt-get update
$ apt-get install -y mssql-tools unixodbc-dev

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

$ sqlcmd -S localhost -U SA -P '<YourPassword>'

$ sqlcmd -S localhost -U SA
Password:
1>

1> CREATE DATABASE TestDB

2> GO

1> SELECT Name from sys.Databases
2> GO
Name
----------------------------------------
master
tempdb
model
msdb
TestDB

(5 rows affected)

1> USE TestDB

2> CREATE TABLE Inventory (id INT, name NVARCHAR(50), quantity INT)

3> INSERT INTO Inventory VALUES (1, 'banana', 150); INSERT INTO Inventory VALUES (2, 'orange', 154);

4> GO

1> USE TestDB
2> CREATE TABLE Inventory (id INT, name NVARCHAR(50), quantity INT)
3> INSERT INTO Inventory VALUES (1, 'banana', 150); INSERT INTO Inventory VALUES (2, 'orange', 154);
4> GO
Changed database context to 'TestDB'.

(1 rows affected)

(1 rows affected)

1> SELECT * FROM Inventory WHERE quantity > 152;
2> GO
id          name         quantity
------ ------------ -----------
     2 orange       154

(1 rows affected)

1> QUIT

$ apt-get remove mssql-server

$ sudo rm -rf /var/opt/mssql/