How to install Azure Data Studio on Linux to manage your SQL servers

Data is one of the most valuable assets for most modern businesses. A database is often used to store the data, provide a smooth user experience, and provide insight into operations.

Here we show you how to get started with Azure Data Studio on Linux. You can use it to design, query and manage your data or SQL Server databases in the cloud or at your premises.

What is Azure Data Studio?

Azure Data Studio is a cross-platform database management tool available for Mac, Windows, and Linux. Azure Data Studio has most of the features that Microsoft SQL Server Management Studio (SSMS) has, but is lighter and more extensible. However, it is not intended to be a replacement for SSMS.

You can use Azure Data Studio for both cloud-based and on-premises databases. It is very modular in design and uses software extensions to add or expand its functionality. For example, you can use it to connect to PostgreSQL.

Azure Data Studio was built for the modern software developer or data analyst. Some of its core features include:

  • Highly customizable dashboards to monitor your databases
  • A built-in terminal window for interacting with your databases via PowerShell, Bash, etc.
  • Supports Jupyter notebooks
  • A SQL query editor with IntelliSense support

Azure Data Studio is fully open source and you can access it Code base on GitHub.

MAKEUSEOF VIDEO OF THE DAY

Install Azure Data Studio on Linux

Before beginning the installation, download the Azure Data Studio package that corresponds to the currently running distribution.

Download: Azure Data Studio (Free)

On Debian and Ubuntu based distributions

If you are using a Debian-based distribution such as Ubuntu, download the appropriate DEB package and use the following cd command to navigate to the download directory:

cd ~/Downloads

Then install Azure Data Studio using APT Package Manager.

sudo apt install ./azuredatastudio-linux-*.deb

On RHEL, CentOS and Fedora

For Red Hat Enterprise Linux (RHEL) and its derivatives, download the RPM file and then navigate to the Downloads directory.

cd ~/Downloads

Install Azure Data Studio using YUM as follows:

sudo yum install ./azuredatastudio-linux-1.35.1.rpm

Run the following command to download the required dependencies:

sudo yum install libXScrnSaver

Under Arch Linux

You can install Azure Data Studio on Arch-based distributions using Yay:

yay -S azuredatastudio-bin

Launch Azure Data Studio


Azure Data Studio home page

You can launch Azure Data Studio from the Applications menu on your system or from the terminal by running the following command:

azuredatastudio

connection to a database

You can easily connect to your cloud or on-premises databases from the Azure Data Studio main page. If you have already connected to other databases, you can find them in the left sidebar.

A green dot means that you are currently connected to the respective database, while a red dot symbolizes that you are not connected.


Start a new database connection in Azure Data Studio

Click on that New connection and Azure Data Studio will show you a connection screen where you can enter your credentials and other database details.

Enter the name of the server you want to connect to and provide the required credentials. We’re using SQL login here, but you can use Windows authentication if you prefer.


Create a new database connection in Azure Data Studio

Finally click on the Connect Button to connect to your SQL Server database.

Use the Progressive Button to access more connection configurations like preferred ports, connection timeout and other security configurations to keep your data safe and secure.

Uninstalling Azure Data Studio

On Debian-based distributions, you can uninstall Azure Data Studio with the apt remove command:

sudo apt remove azuredatastudio

On RHEL, Fedora, and similar distributions, uninstall Azure Data Studio by running the following command:

sudo yum remove azuredatastudio

To uninstall Azure Data Studio downloaded from the AUR on Arch Linux:

sudo yay -R azuredatastudio-bin

Access your cloud and on-premises databases on Linux

This guide showed you how to access your cloud and on-premises database instances using Azure Data Studio on Linux. It’s lightweight, easy to set up, and available on all major operating systems, including macOS, Windows, and Linux.

Azure Data Studio also supports backup and restore of databases for data or disaster recovery. With Azure Data Studio, you can easily restore corrupted data when needed.


SQL server concept

SQL Server data has been corrupted? Try to recover it with SQL Recovery Toolbox

continue reading


About the author

About Willie Ash

Check Also

Don’t commit yourself! Here are solid alternatives for Apple’s weaker software

One of the best things about Apple’s Macintosh computers is that they come with a …