MS SQL Express
Aus d0b
Zur Navigation springenZur Suche springenMS 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