DB

MSSQL

June 16, 2020

Install mssql

sudo apt remove gpg
sudo apt update -y
sudo apt install -y gnupg1
wget -qO- https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -

sudo apt-get -y install software-properties-common
sudo add-apt-repository "$(wget -qO- https://packages.microsoft.com/config/ubuntu/18.04/mssql-server-2019.list)"

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

Install mssql tool

curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -
curl https://packages.microsoft.com/config/ubuntu/18.04/prod.list | sudo tee /etc/apt/sources.list.d/msprod.list
sudo apt-get update

wget http://archive.ubuntu.com/ubuntu/pool/main/g/glibc/multiarch-support_2.23-0ubuntu11_amd64.deb
apt install ./multiarch-support_2.23-0ubuntu11_amd64.deb
sudo apt-get update --fix-missing
sudo apt-get upgrade
sudo apt autoremove
sudo apt-get install -y mssql-tools unixodbc-dev
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
source ~/.bashrc

Install ODBC for tool

curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add -
curl https://packages.microsoft.com/config/ubuntu/20.04/prod.list > /etc/apt/sources.list.d/mssql-release.list
sudo apt-get update
sudo /opt/mssql/bin/mssql-conf setup > edition 3
sqlcmd -S localhost -U SA -P $PWD