« Sql server for linux » : différence entre les versions

De Banane Atomic
Aller à la navigationAller à la recherche
Ligne 3 : Ligne 3 :
= [[Ubuntu_server_16.04#SQL_Server|Ubuntu 16.04]] =
= [[Ubuntu_server_16.04#SQL_Server|Ubuntu 16.04]] =


= Ubuntu 18.04 ARM =
= ARM =
<kode lang='bash'>
{{warn | SQL Server is not supported on ARM architecture.}}
# Import the public repository GPG keys
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>
 
# Register the Microsoft SQL Server Ubuntu repository for SQL Server 2019
sudo add-apt-repository "$(wget -qO- https://packages.microsoft.com/config/ubuntu/18.04/mssql-server-2019.list)"
# add-apt-repository: command not found
# sudo apt install software-properties-common
# /etc/apt/sources.list
# deb [arch=amd64,armhf,arm64] https://packages.microsoft.com/ubuntu/18.04/mssql-server-2019 bionic main
</kode>


= Archlinux =
= Archlinux =

Version du 20 janvier 2020 à 20:07

Ubuntu 16.04

ARM

SQL Server is not supported on ARM architecture.

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
Récupérée de « http://wiki.bananeatomic.fr/index.php?title=Sql_server_for_linux&oldid=22856 »