How to Install Microsoft SQL Server in Ubuntu Linux

How to set up Microsoft SQL Server on Ubuntu Linux. All commands are in description below.

Follow me on YouTube: https://www.youtube.com/jeremymorgan?sub_confirmation=1

Twitter: https://twitter.com/jeremycmorgan
My Twitch Channel: https://www.twitch.tv/jeremymorgan

Check out my Blog: https://www.jeremymorgan.com/

~ sudo apt-get update
~ sudo apt-get upgrade

~ curl https://packages.microsoft.com/keys/m… | sudo apt-key add –

~ curl https://packages.microsoft.com/config… | sudo tee /etc/apt/sources.list.d/mssql-server.list

~ sudo apt-get update
~ sudo apt-get install -y mssql-server

~ sudo /opt/mssql/bin/sqlservr-setup

~ systemctl status mssql-server

~ curl https://packages.microsoft.com/config… | sudo tee /etc/apt/sources.list.d/msprod.list

~ sudo apt-get update
~ sudo apt-get install mssql-tools

~ sqlcmd -S localhost -U SA -P ‘(Your Password)’

~ SELECT Name from sys.Databases;
~ GO

~ CREATE DATABASE acmewidgets;
~ GO

~ USE acmewidgets;
~ GO

~ CREATE TABLE customer (id INT, firstname NVARCHAR(50), lastname NVARCHAR(50));
~ GO

~ INSERT INTO customer VALUES (1, ‘Lloyd’, ‘Christmas’);
~ INSERT INTO customer VALUES (2, ‘Harry’, ‘Dunn’);
~ INSERT INTO customer VALUES (3, ‘Mary’, ‘Swanson’);
~ GO

~ SELECT * FROM customer
~ GO

~ QUIT

source

by Jeremy Morgan

linux web server