Power Community

Power Community

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

https://arunpotti.files.wordpress.com/2023/01/image-105.png

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?

This post was originally published on this site

- Advertisement -spot_img

LEAVE A REPLY

Please enter your comment!
Please enter your name here

- Advertisement - Advertisement

Latest News

Enable Early Access Wave 1 2023 | Power Platform

Like every 6 months, enabling Early Access is one of the best things to look forward to as Microsoft...

More Articles Like This

- Advertisement -spot_img