How to Connect Azure SQL Database in the Azure Data Studio?

Azure Data Studio is a cross-platform database tool for data professionals who use on-premises and cloud data platforms on Windows, macOS, and Linux.

Azure Data Studio offers a modern editor experience with IntelliSense, code snippets, source control integration, and an integrated terminal. It’s engineered with the data platform user in mind, with the built-in charting of query result sets and customizable dashboards.

Follow the below steps to connect to Azure SQL Database in the Azure Data Studio.

Pre-requisite:

Download and Install Azure Data Studio on Windows Machine

Step 1: Launch Azure Data Studio.

Step 2: Click on the New Connection under New drop down.

Or

Click on Create a connection.

Step 3: Choose the Connection String option, Provide the Connection string [ADO.NET (SQL authentication)] text and give some meaningful Name to the Connection Details.

Click on Connect.

Note: For reference, follow my earlier article’s Step 17 to get the Azure SQL ADO.NET (SQL authentication) Connection string in the Azure portal.

Create Azure SQL Database in the Microsoft Azure Portal

Once it is connected successfully, you can see the below message Connected

Below Query window will be opened automatically in a few seconds, where you can see the list of Tables, Views, Stored Procedures etc.

Step 4: Click on New Query.

Step 5: Enter the below command and click on Run.

Results can be seen like the below.

Hope you have successfully followed all the steps and Connected to Azure SQL Database from the Azure Data Studio.

Like and share your valuable feedback on this article.

My earlier articles related to Azure that you might like,

How to create Microsoft Azure Trial Version?

How to Create Azure Service Bus and Queue in Microsoft Azure Portal?

How to Download Microsoft Azure Architecture Icons?

How to Create Azure SQL Database Server in the Microsoft Azure Portal?

How to Create Azure SQL Database in the Microsoft Azure Portal?

How to Register an App in Azure Active Directory for Dynamics 365 CE Online?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.