MS SQL Express

Aus d0b
Zur Navigation springenZur Suche springen

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