Microsoft SQL Server sur Ubuntu 20.04

Installation

Mettre à jour le système

apt update apt dist-upgrade

Installer quelques paquets nécessaires

apt install gnupg curl software-properties-common

Ajouter la clé du repository MS

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

Ajouter le repository

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

Installer

apt update apt install mssql-server

Configurer mssql

/opt/mssql/bin/mssql-conf setup

Choisir 3 - Express

Reste en vrac:

curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add - curl https://packages.microsoft.com/config/ubuntu/19.10/prod.list > /etc/apt/sources.list.d/mssql-release.list apt update apt-get install mssql-tools unixodbc-dev echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile

Sources

https://computingforgeeks.com/how-to-install-ms-sql-on-ubuntu/

https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-encrypted-connections?view=sql-server-ver15