Questions tagged [azure-data-studio]

Use this tag for issues related to Azure Data Studio and try tagging the platform as well. Ask the question on superuser.com if you are facing issues with installation

Azure Data Studio is a data management tool that enables working with SQL Server, Azure SQL DB and SQL DW from Windows, macOS and Linux. This is similar to Sql Server Management Studio, but works on all platforms.

Github: https://github.com/Microsoft/azuredatastudio

253 questions
1
vote
2 answers

How to Collapse All Regions in Azure Data Studio

I used to use SSMSBOOST in Microsoft SQL Server Management Studio https://www.ssmsboost.com/ where it add "REGIONS" support to the editor, which is very helpful to organize the scripts. But Recently with my switch to user Microsoft Azure Data Studio…
Walid Haidari
  • 125
  • 2
  • 10
1
vote
1 answer

Azure Data Studio: Save As CSV with header

I saw the article on how to save the result of the query as csv. Is it possible to save it with header? Reference: Azure Data Studio: Save As CSV
Joyce
  • 1,431
  • 2
  • 18
  • 33
1
vote
2 answers

Azure Data Studio - Detach Results Window

Is it possible to detach the Results Window, in Azure Data Studio? I have multiple monitors and I want to use them on this program as well :) I know Windows+Shift+R shows/hide the window, what I need is to detach it (Floating Window)
Cătălin Rădoi
  • 1,804
  • 23
  • 43
1
vote
2 answers

Backup SQL Server 2019 in a Docker Linux container fails

Attempted multiple ways to do the backup. Tried adding SA as a root user in the container Azure Data studio BACKUP DATABASE [PrestigeCars] TO DISK = N'/var/opt/mssql/backup//PrestigeCars-202044-8-4-52.bak' WITH NOFORMAT, NOINIT, NAME =…
Peter H
  • 109
  • 1
  • 8
1
vote
1 answer

How to HyperLink a value in Azure Data Studio?

I am using/exploring the below code to hyperlink a value in SQL Server. In SSMS, for both On-Premises DB and Azure SQL DB, it works fine. When I run the same query through Azure Data Studio, not able to see the hyperlinked value in result set. For…
1
vote
0 answers

ADS -- Run Button Dimming

Context: I'm running some simple queries in Azure Data Studio to query and manipulate data in a local instance of SQL Server 2019. Question: When I query the table via "Select", the Run button is accessible. As soon as I Truncate the table, the Run…
emalcolmb
  • 1,585
  • 4
  • 18
  • 43
1
vote
0 answers

Is there a way to source control an entire database, not just scripts that I choose to save to my git enabled folder?

Using Azure Data Studio, is there a way or extension that allows me to mark a database as being under source control, and upon doing so, have it automatically add my changes to source control. Instead it seems I have to save each alter statement to…
Dave
  • 649
  • 5
  • 13
1
vote
1 answer

Azure Data Studio support for Catalina

Is Catalina supported as part of Azure Data Studio? The documentation here (https://learn.microsoft.com/en-us/sql/azure-data-studio/download-azure-data-studio?view=sql-server-ver15) doesn't make mention of this specifically, and I got a following…
thomassantosh
  • 571
  • 1
  • 6
  • 21
1
vote
2 answers

How to connect to an SQL Server on Parallels VM

I'm attempting to connect to a test Database on a Parallels VM on Mac using Azure Data Studio, but I'm getting the standard, generic connection error: System.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error…
Web Develop Wolf
  • 5,996
  • 12
  • 52
  • 101
1
vote
2 answers

Creating SQL Server in Amazon, cannot connect to it using Azure Data Studio

I've created a SQL Server in AWS, here is the screenshot. Then, I've pasted the endpoint, and try to connect using Azure Data Studio. However; I couldn't connect to SQL Server I created through AWS. Here is the error message:…
Steven Z.
  • 47
  • 1
  • 11
1
vote
0 answers

Azure Data Studio Uses Single Quotes for JSON

I can't find a setting in Azure Data Studio, if there is one, that will display JSON results with double quotes rather than singles. Example: 'EarliestStartDate': '2020-01-04T00:00:00' A little bit of extra effort is needed when copying and pasting…
domusvita
  • 818
  • 7
  • 7
1
vote
1 answer

Azure Data Studio An error occurred while loading file data

I am trying to restore my MSSQL database in Azure Data Studio. I right click the database, click restore, the change Restore from to Backup File. Then I click the 3 dots in the Backup file path and then it loads a while and gives me this error:
Paul Kruger
  • 2,094
  • 7
  • 22
  • 49
1
vote
1 answer

Use Azure Data Studio to see SQL Server from container

I'm developing an .NET Core application. I use docker following this tutorial : https://docs.docker.com/compose/aspnet-mssql-compose/ So, thanks to docker compose I have dockerized my application and my SQL Server. Now, I want to see my Database…
Nemtecl
  • 355
  • 1
  • 3
  • 14
1
vote
2 answers

Connect to Team Foundation Server from Azure Data Studio

I have connected team foundation server with Visual studio 2017 for source control using the team explorer plug in. I am trying to do the same with azure data studio. The main purpose is to add source control for the database objects like stored…
1
vote
1 answer

Import csv file is not working as expected with azure data studio

I'm trying to import some csv files with azure data studio but after user the import wizard tool this did not fill the columns in the right way it just create 2 columns and put all the data I'm those by the way is working fine with txt files. Any…
UserEsp
  • 415
  • 1
  • 7
  • 29