Installer SQL Server 2019 sur Linux Mint 20

Installation de SQL Server

Importer les clefs publiques GPG de Microsoft :

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

Ajouter le repository de Microsoft SQL Server pour Ubuntu :

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

Lancer l’installation

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

 

Configuration de SQL Server

Lancer la configuration

sudo /opt/mssql/bin/mssql-conf setup

Choisir un mot de passe et l’édition 2 (développeur)

Tester si le service SQL Server tourne

Taper :

systemctl status mssql-server –no-pager

Résultat :

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 2021-01-14 08:58:21 CET; 25min ago
       Docs: https://docs.microsoft.com/en-us/sql/linux
   Main PID: 948 (sqlservr)
      Tasks: 174
     Memory: 1.8G
     CGroup: /system.slice/mssql-server.service
             ├─ 948 /opt/mssql/bin/sqlservr
             └─1289 /opt/mssql/bin/sqlservr

Jan 14 08:59:12 lifebook sqlservr[1289]: [96B blob data]
Jan 14 08:59:12 lifebook sqlservr[1289]: [100B blob data]
Jan 14 08:59:12 lifebook sqlservr[1289]: [71B blob data]
Jan 14 08:59:12 lifebook sqlservr[1289]: [124B blob data]
Jan 14 08:59:12 lifebook sqlservr[1289]: [73B blob data]
Jan 14 08:59:12 lifebook sqlservr[1289]: [186B blob data]
Jan 14 08:59:12 lifebook sqlservr[1289]: [73B blob data]
Jan 14 08:59:12 lifebook sqlservr[1289]: [186B blob data]
Jan 14 09:09:58 lifebook sqlservr[1289]: [155B blob data]
Jan 14 09:09:58 lifebook sqlservr[1289]: [205B blob data]

Installation de Azure Data Studio

Télécharger ADS pour Debian

https://go.microsoft.com/fwlink/?linkid=2151506

cd ~
sudo dpkg -i ./Downloads/azuredatastudio-linux-1.25.1.deb
azuredatastudio

Installer les dépendances manquante

sudo apt-get install libxss1
sudo apt-get install libgconf-2-4
sudo apt-get install libunwind8