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

De Banane Atomic
Aller à la navigationAller à la recherche
 
(12 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]] =
= ARM =
{{warn | SQL Server is not supported on ARM architecture.}}


= 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 12 : 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>
 
= [https://docs.microsoft.com/en-us/sql/azure-data-studio/what-is?view=sql-server-linux-ver15 Azure Data Studio] =
== Extensions ==
{| class="wikitable wtp"
! Nom de l'extension
! Description
|-
| [https://github.com/wsr-publishing/azure-poor-formatter Poor SQL Formatter] || format SQL code
|-
| [https://github.com/kevcunnane/azuredatastudio-newdatabase/releases/tag/1.0.0 New database] || ajoute l'entrée "New database" au menu contextuel
|}

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 »