Sql server for linux

De Banane Atomic
Aller à la navigationAller à la recherche

Ubuntu 16.04

Ubuntu 18.04 ARM

Bash.svg
wget -qO- https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -
# apt-key list
# pub   rsa2048 2015-10-28 [SC]
#       BC52 8686 B50D 79E3 39D3  721C EB3E 94AD BE12 29CF
# uid           [ unknown] Microsoft (Release signing) <gpgsecurity@microsoft.com>
# supprimer la clé?
apt-key del 'BC52 8686 B50D 79E3 39D3  721C EB3E 94AD BE12 29CF'

Archlinux

Installation

Bash.svg
yaourt mssql-server

# vérifier que le serveur a bien démarré
sc-status mssql-server

mssql-conf setup problem

SQL ne démarre pas car la configuration ne s'est pas faite durant l'installation.

Bash.svg
sc-start mssql-server
# Started Microsoft SQL Server Database Engine.
# Failed to determine user credentials: No such process
# Failed at step USER spawning /opt/mssql/bin/sqlservr: No such process

Il faut relancer la configuration

Bash.svg
sudo /opt/mssql/bin/mssql-conf setup
# /bin/bash: /opt/mssql/bin/../lib/mssql-conf/mssql-conf.py: /usr/bin/python22: bad interpreter: No such file or directory

Modifier l'interpréteur et relancer la configuration

/opt/mssql/lib/mssql-conf/mssql-conf.py
#!/usr/bin/python2

Installation d'Azure Data Studio

Bash.svg
yaourt azuredatastudio

Azure Data Studio

Extensions

Nom de l'extension Description
Poor SQL Formatter format SQL code
New database ajoute l'entrée "New database" au menu contextuel