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.
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:
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.
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
You can launch Azure Data Studio from the Applications menu on your system or from the terminal by running the following command:
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.
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.
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 data has been corrupted? Try to recover it with SQL Recovery Toolbox
About the author