SQL Server on Linux
from the Artful SQL Server & Access Tips List
A Microsoft page introducing SQL Server for Linux
links to installation command sequences that execute in the terminal window of several popular flavours of Linux. For each of SQL Server itself, MS Tools, and SQL Server commandline tools, you'll find there are pages setting out commands for updating your repository, registering it, downloading and installing the software, and configuring it.
Once you do the installation and configuration, starting sqlcmd
is straightforward. In a terminal window execute the following, substituting your SQL Server password for
sqlcmd -S localhost -U SA -P 'PWD'
That will drop you into the SQL Server commandline tool. What databases exist?
In a virgin SQL Server installation this lists four databases:
master, model, msdb, tempdb
And now you can get to work in SQL Server on Linux.
Return to the Artful SQL Server & Access Tips page