Introduction
Azure Data Studio is a cross-platform database tool for data professionals who use Microsoft on-site and cloud data platforms on Windows, macOS, and Linux.
Azure Data Studio provides advanced IntelliSense editor experience, code snippets, source control functionality, and an interactive console. It's planned with the data platform user in mind, with built-in query result set charts and customizable dashboards.
Azure Data Studio comes with various features like:
- SQL code editor with advance IntelliSense
- Smart SQL code snippets
- Customizable server and customizable database dashboards
- Connection management (server groups)
- Integrated Terminal
- Extensibility and extension authoring
This tutorial will show you various steps on, how to download and install Azure Data Studio on Windows 10.
Who should use Azure Data Studio
The first question that comes to our mind is, why should we use Azure Data Studio? Then, you have to know its characteristics. Azure Data Studio can be used by anyone. However, it is intended to simplify the activities performed by database developers, administrators and managers, network administrators, and individual software vendors.
Is Azure Data Studio Open Source?
I know you are wondering if it is open source or not. Yes, the source code for Azure Data Studio and its data providers is available on GitHub. According to Microsoft, "The source code for the front-end Azure Data Studio (which is based on Visual Studio Code) is available under a source code EULA that provides rights to modify and use the software, but not to redistribute it or host it in a cloud service. The source code for the data providers is available under the MIT license at https://github.com/Microsoft/sqltoolsservice".
Azure Data Studio vs SSMS
| Azure Data Studio |
SQLServer Management Studio |
| It is used by Windows, macOS, or Linux users. |
It is used by Windows users |
| Used to connect to a SQL Server 2019 big data cluster. |
Used to Import/Export of DACPACs. |
| Use ADS, if you spend most of your time in editing or executing queries. |
Use SSMS, if you spend most of your time on database administration tasks. |
| Helpful to check quickly chart and visualize result sets. |
Use SSMS, if you need to use performance tuning advisors and dashboards. |
| It doesn't require deep administrative configuration. |
You can configure security features in SSMS. |
System Requirements
Before downloading and installing Azure Data Studio on Windows 10, the following requirements are essential.
- Operating System Version - Microsoft Windows 10 (64-bit).
- Memory/Random Access Memory (RAM) - Minimum 4 GB RAM and 8 GB recommended.
- Good Internet Connection to download the Azure Data Studio.
Note
Azure Data Studio is also supported on the following versions of Windows.
- Windows 10 (64-bit)
- Windows 8.1 (64-bit)
- Windows 8 (64-bit)
- Windows 7 (SP1) (64-bit) - Requires KB2533623
- Windows Server 2019
- Windows Server 2016
- Windows Server 2012 R2 (64-bit)
- Windows Server 2012 (64-bit)
- Windows Server 2008 R2 (64-bit)
Download and Install Azure Data Studio
Microsoft recommends the user install, as it does not need the privileges of the administrator which simplifies all installations and upgradations. The user installer does not require administrator access, as the location is in the Local AppData (LOCALAPPDATA) folder of your device. To download the Azure Data Studio, follow the below instructions.
Step 1
To download the latest version of Azure Data Studio, visit the official
Azure website in your web browser.
Step 2
Now, download the Azure Data Studio (User installer (recommended)) from here.
Step 3
Navigate the folder where you have downloaded your Azure Data Studio and double-click on the downloaded "Azure Data Studio" file to run.
Step 4
Setup Wizard will appear on the screen. After reading and accepting the terms & conditions, click on the "Next" button to continue.
Step 5
Here, you can choose the location where you want to install the Azure Data Studio. Then, click on the "Next" button to proceed.
Step 6
Click on the "Next" button to continue.
Step 7
Select the various additional task as per your needs, and click on the "Next" button to proceed.
Step 8
Now, your setup is ready to install Azure Data Studio. And, click on the "Install" button to continue.
Step 9
Finally, click on the "Finish" button to launch the Azure Data Studio.
Congratulations! You have successfully installed the "Azure Data Studio" on Windows 10 and the welcome screen will appear on the screen.
How To Connect Azure Data Studio
To connect with Azure Data Studio, you must have to meet the following requirements.
- Azure Data Studio
- SQL Server (latest version)
To Connect Azure Dara Studio, follow the below instructions to proceed.
Step 1
Open Azure Data Studio and click on the "New Connection" option/button to open the "Connection" pane.
Step 2
Now, I am describing how to connect using SQL Server 2019 instance via the "SQL Login" authentication type. Fill all the details as follows:
Connection Type: Microsoft SQL Server
Server: <Machine Name>\<SQL Server Instance Name>
Authentication Type: SQL Login
User name: sa
Password: xxxxxxxxxxx
Then, click on the "Connect" button.
Now, all the details of your database are shown here including, Server properties, Backup Status, and Database Size (which are shown in a very attractive way).
References
https://docs.microsoft.com/en-us/sql/azure-data-studio/?view=sql-server-ver15
Conclusion
In this article, we discussed how to download, install, and connect the Azure Data Studio on Windows 10.
I hope you enjoyed this article. Follow C# Corner to learn more new and amazing things about Microsoft Azure.
Thanks for reading!