« Sql server for linux » : différence entre les versions
De Banane Atomic
Aller à la navigationAller à la recherche
| Ligne 5 : | Ligne 5 : | ||
= Ubuntu 18.04 ARM = | = Ubuntu 18.04 ARM = | ||
<kode lang='bash'> | <kode lang='bash'> | ||
# Import the public repository GPG keys | |||
wget -qO- https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add - | wget -qO- https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add - | ||
# apt-key list | # apt-key list | ||
| Ligne 10 : | Ligne 11 : | ||
# BC52 8686 B50D 79E3 39D3 721C EB3E 94AD BE12 29CF | # BC52 8686 B50D 79E3 39D3 721C EB3E 94AD BE12 29CF | ||
# uid [ unknown] Microsoft (Release signing) <gpgsecurity@microsoft.com> | # uid [ unknown] Microsoft (Release signing) <gpgsecurity@microsoft.com> | ||
# | |||
apt- | # 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> | </kode> | ||
Version du 20 janvier 2020 à 19:47
Ubuntu 16.04
Ubuntu 18.04 ARM
|
# 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 |
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 |
