Sql server for linux

Ubuntu 18.04 ARM

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

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.

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

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

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