Install Azure Data Studio on Ubuntu 18.04

Azure Data Studio is a graphical tool for managing databases.

It is available on Windows, MacOS, and Linux. On Linux it’s available on Red Hat (RHEL), SUSE Linux Enterprise Server, and Ubuntu.

Below is a step-by-step guide to installing Azure Data Studio on Ubuntu 18.04 via the GUI. Screenshots included.

I’ve also provided the commands for installation via the command-line in case you prefer that method.

Download Azure Data Studio

You can download the latest Azure Data Studio release from the Microsoft website.

I used Firefox in this example.

Go to the Microsoft Download page, look for the Linux options:

Screenshot of the Microsoft website for downloading Azure Data Studio, with an arrow pointing at the Linux .deb option

Click the .deb option.

You’ll be prompted to either save the file or open it:

Screenshot of the Save File dialog box in Firefox

Select the Save File option, then click OK.

This will download the file to your computer.

Once downloaded you should see the file listed:

Screenshot of the downloaded file

Click on the file.

Install Azure Data Studio

After clicking the above file, the following screen is displayed:

Screenshot of the Install button

Click Install.

You may be prompted to authenticate:

Screenshot of the authentication prompt

Enter your password as required.

This installation process now begins:

Screenshot of the installation in progress

It shouldn’t take too long.

Once installed, the Install button will change to Remove:

Screenshot of the successful installation screen, with the Remove button

This means that Azure Data Studio has been successfully installed!

Open Azure Data Studio

You can find Azure Data Studio amongst your Applications by clicking on the Show Applications icon – the nine dotted square at the bottom left of the screen:

Screenshot of the various Applications

You can also filter the applications by searching for azure:

Screenshot of the Azure Data Studio icon

Clicking on the Azure Data Studio icon will launch it:

Screenshot of Azure Data Studio

To start using it, click New connection under the Start heading near the top left.

You will be prompted to set up a new connection:

Screenshot of the New Connection box in Azure Data Studio

Enter the server, user name, and password.

The following screenshot shows me logging in to my local SQL Server instance. In that case, I used localhost as the server name. I used the sa account to log in with:

Screenshot of the New Connection box in Azure Data Studio with details filled in

Once you entered your details, click Connect.

This should open the connection:

Screenshot of the Azure Data Studio after connecting

You can now go ahead and create databases, run queries, etc

Click the New Query button to open a new query tab.

You can also click the Connections icon near the top left of the screen to reveal all the connections. This allows you to navigate the servers, databases, objects, etc.

Screenshot of the New Query tab, and the Connections menu in Azure Data Studio

Command-Line Installation

If you prefer to do things by the command-line, you can install Azure Data Studio by opening Terminal, and entering the following:

cd ~
sudo dpkg -i ./Downloads/azuredatastudio-linux-1.24.0.deb

Replace 1.24.0 with the version that you’re installing. You can see this in the name of the .deb file.

Note that this still requires that you’ve downloaded the .deb file from the Microsoft website as mentioned above.

You can now launch Azure Data Studio with the following command:

azuredatastudio

Depending on your setup, it’s possible that you may have missing dependencies. If so, running the following should sort this out:

sudo apt-get install libxss1

sudo apt-get install libgconf-2-4

sudo apt-get install libunwind8

Can I Install it on a Different Machine to My Database Server?

Yes. And in most cases, you probably should install Azure Data Studio on a different machine to the database Server.

In the above example, I installed Azure Data Studio on to the same machine that SQL Server is running on, then used localhost to connect. You probably won’t want to do this in your production environment.

Either way, the instructions are the same regardless of whether you have SQL Server on the same machine or not. You can (and typically should) install Azure Data Studio on one machine, and then connect to the database server on another machine.