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
Commentaires