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
by Jeremy Morgan
linux web server