Install cross platform data tools

cross-platform data tools

	Tool	Description
	SQL Server command-line tools	sqlcmd and bcp
✓	Azure Data Studio	A cross-platform GUI database management utility.
✓	Visual Studio Code	A cross-platform GUI code editor that run Transact-SQL statements with the mssql extension.
	PowerShell Core	A cross-platform automation and configuration tool based on cmdlets.
	mssql-cli	A cross-platform command-line interface for running Transact-SQL commands.

install azure data studio

download latest version
update
– if installer package is in /Downloads folder
cd ~
sudo dpkg -i ./Downloads/azuredatastudio-linux-1.24.0.deb
– else , cd to the folder conating the package & adapt above command
cd /mnt/data/install
sudo dpkg -i /mnt/data/install/azuredatastudio-linux-1.36.2.deb

Install SQL Server command-line tools :

zie https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-ubuntu?view=sql-server-linux-ver15&preserve-view=true

By default, curl isn’t installed on Ubuntu. To install curl, run this code:
sudo apt-get update
sudo apt install curl

import the public repository GPG keys.
curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -
Register the Microsoft Ubuntu repository.
curl https://packages.microsoft.com/config/ubuntu/20.04/prod.list | sudo tee /etc/apt/sources.list.d/msprod.list

see Install the Microsoft ODBC driver for SQL Server (Linux).
sudo apt-get update
sudo apt-get install mssql-tools unixodbc-dev

update to the latest version of mssql-tools run the following commands:
sudo apt-get update
sudo apt-get install mssql-tools