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

De Banane Atomic
Aller à la navigationAller à la recherche
 
(7 versions intermédiaires par le même utilisateur non affichées)
Ligne 1 : Ligne 1 :
[[Category:SQL Server]]
[[Category:SQL Server]]
[[Category:Linux]]
[[Category:Linux]]
= Links =
* [https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-overview?view=sql-server-linux-ver15 SQL Server on Linux]
= [[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 =
== Installation ==
== Installation ==
<kode lang='bash'>
<kode lang='bash'>
yaourt mssql-server
yay mssql-server
 
# configure the server
sudo /opt/mssql/bin/mssql-conf setup


# vérifier que le serveur a bien démarré
# vérifier que le serveur a bien démarré
Ligne 29 : Ligne 21 :
</kode>
</kode>


=== mssql-conf setup problem ===
== Installation d'Azure Data Studio ==
SQL ne démarre pas car la configuration ne s'est pas faite durant l'installation.
<kode lang='bash'>
<kode lang='bash'>
sc-start mssql-server
yay azuredatastudio
# 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
</kode>
</kode>


Il faut relancer la configuration
== Install the SQL Server command-line tools ==
<kode lang='bash'>
<kode lang='bash'>
sudo /opt/mssql/bin/mssql-conf setup
yay mssql-tools
# /bin/bash: /opt/mssql/bin/../lib/mssql-conf/mssql-conf.py: /usr/bin/python22: bad interpreter: No such file or directory
</kode>
</kode>


Modifier l'interpréteur et relancer la configuration
= Errors =
<filebox fn='/opt/mssql/lib/mssql-conf/mssql-conf.py'>
== Server is in script upgrade mode. Only administrator can connect at this time. ==
#!/usr/bin/python2
Wait for the server to finish updating. Then try to connect again.
</filebox>
 
== Installation d'Azure Data Studio ==
<kode lang='bash'>
yaourt azuredatastudio
</kode>


= [https://docs.microsoft.com/en-us/sql/azure-data-studio/what-is?view=sql-server-linux-ver15 Azure Data Studio] =
= [https://docs.microsoft.com/en-us/sql/azure-data-studio/what-is?view=sql-server-linux-ver15 Azure Data Studio] =

Dernière version du 19 juin 2021 à 23:32

Links

Ubuntu 16.04

ARM

SQL Server is not supported on ARM architecture.

Archlinux

Installation

Bash.svg 
yay mssql-server

# configure the server
sudo /opt/mssql/bin/mssql-conf setup

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

Installation d'Azure Data Studio

Bash.svg 
yay azuredatastudio

Install the SQL Server command-line tools

Bash.svg 
yay mssql-tools

Errors

Server is in script upgrade mode. Only administrator can connect at this time.

Wait for the server to finish updating. Then try to connect again.

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=26038 »