MS SQL Express
Aus d0b
Version vom 27. November 2019, 13:03 Uhr von Sysd0b (Diskussion | Beiträge) (Die Seite wurde neu angelegt: „'''MS SQL Express Server''' - Installation <pre> wget -qO- https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add - …“)
MS SQL Express Server - Installation
wget -qO- https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add - // GPG-Key Importieren sudo add-apt-repository "$(wget -qO- https://packages.microsoft.com/config/ubuntu/16.04/mssql-server-2017.list)" // Repo hinzufügen sudo apt-get update // Paketlisten updaten sudo apt-get install -y mssql-server // Server Installerieren sudo /opt/mssql/bin/mssql-conf setup // Setup zur Ersteinrichtung systemctl status mssql-server --no-pager // Status abfragen sudo systemctl stop mssql-server // Server stoppen sudo systemctl start mssql-server // Server starten /opt/mssql/bin/mssql-conf set-sa-password // "SA" PW Reset
CLI Tools -
sudo apt-get install mssql-tools // Installieren sqlcmd -S localhost -U SA -P 'PASSWORT' // Am SQL Server anmelden
MS SQL Express Server - DB Syntax Alle Datenbanken anzeigen
USE master select name from sys.databases go
MS SQL Links
- https://www.sqlservercentral.com/blogs/reset-sa-password-on-sql-server-on-linux
- https://docs.microsoft.com/de-de/sql/relational-databases/system-catalog-views/sys-databases-transact-sql?view=sql-server-2017
- https://docs.microsoft.com/de-de/sql/relational-databases/databases/view-a-list-of-databases-on-an-instance-of-sql-server?view=sql-server-2017