How to Install SQL Server on Ubuntu

1.  Install SQL Server by opening the terminal window, and type the following:

mkdir sql

cd sql

wget -qO- https://packages.microsoft.com/keys/microsoft.asc > microsoft.asc

sudo apt-key add microsoft.asc

wget -qO- https://packages.microsoft.com/config/ubuntu/18.04/mssql-server-2019.list > mssql-

sudo add-apt-repository "$(cat mssql-server-2019.list)"

sudo apt-get update

sudo apt-get install -y mssql-server

sudo /opt/mssql/bin/mssql-conf setup

Password: #############

systemctl status mssql-server --no-pager

2.   I installed Azure Data Studio, which is a cross-platform and open-source desktop tool for your environments, whether in the cloud, on-premises, or hybrid. To administer SQL Server, you will need to install Azure Data Studio from this website.

In Firefox go to:

https://docs.microsoft.com/en-us/sql/azure-data-studio/download-azure-data-studio?view=sql-server-2017

Click .deb

sudo apt install ~/Downloads/azuredatastudio-linux-1.25.1.deb

azuredatastudio

New Connection

            1. Microsoft SQL Server

            2. localhost

            3. SQL Login

            4. Username: SA

            5. Password: ############

            6. Connect

3. Install ms sql tools. Open the Terminal Window and type the following commands:
     

wget -qO- https://packages.microsoft.com/config/ubuntu/18.04/prod.list > prod.list
      

sudo cp prod.list /etc/apt/sources.list.d/msprod.list
      

sudo add-apt-repository "$(cat prod.list)"
      

sudo apt-get install mssql-tools unixodbc-dev