« Sql server for linux » : différence entre les versions
De Banane Atomic
Aller à la navigationAller à la recherche
Aucun résumé des modifications |
|||
| Ligne 38 : | Ligne 38 : | ||
= [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] = | ||
== 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 | |||
|} | |||
Version du 11 janvier 2020 à 14:23
Ubuntu 16.04
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 |
