Stack Overflow
Stack Overflow

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
5
votes
1 answer

Find connection string for DB in Rider/Azure Data Studio. SQL

I created server through docker with command: docker run -d — name MySQLServer -e ‘ACCEPT_EULA=Y’ -e ‘SA_PASSWORD=your_password123’ -p 1433:1433 mcr.microsoft.com/azure-sql-edge I'm working on an M1 Mac, and everything works fine. I created test DB…
FX_Sektor
  • 1,206
  • 2
  • 14
  • 32
5
votes
1 answer

Azure Data Studio - way to change default connection type for Azure SQL Databases?

I just recently started to use Azure Data Studio to replace SSMS and VS Code. So far it is working great. I do have one "issue" I was wondering if anyone else encounters. I run the application with my Azure AD Admin. Under Connections I see all of…
Blake Murray
  • 51
  • 2
5
votes
2 answers

Select query shortcut in Azure Data Studio 1.9.0

How can I create query shortcut for 'select * from' in Azure Data Studio ver 1.9.0? I see option to go to Keyboard shortcuts (Azure Data Studio / Preferences / Keyboard Shortcuts) but no query shortcuts. When I type select, I do get drop down for…
Anuj Balan
  • 7,629
  • 23
  • 58
  • 92
5
votes
3 answers

How to change the connection name in Azure Data Studio?

I noticed that in the context menu of any connection in Azure Data Studio, there is no rename option. Also, you cannot rename the connection in the Dashboard that opens when you click "Manage" in the mentioned above context menu. Is there any way to…
Dark Templar
  • 1,175
  • 13
  • 27
4
votes
3 answers

Azure Data Studio Failed to Expand Node

I just installed Azure Data Studio (ADS) and PostgreSQL extension. ADS connects to my Postgresql and I can do queries on my database. However, the dropdown 'Databases' tab does not expand. When I right click, to do Refresh, an error message shows up…
TimB
  • 71
  • 1
  • 9
4
votes
1 answer

Azure Data Studio - Database Project - schema compare changes failed

I can successfully build my DB project in the Azure data studio with the SQL DB Projects extension. (not with SSDT but similar to this: https://www.sqlshack.com/two-ways-to-build-sql-database-projects-in-azure-data-studio/ When I right-click on the…
Chris
  • 143
  • 7
4
votes
1 answer

Azure Data Studio does not recognize Kerberos Ticket in MacOS Monterey

I am attempting to connect to a Microsoft SQL Server database on a corporate network that is limited to Windows Authentication. I have configured Kerberos and Kerberos does successfully issue a ticket and I can verify that the ticket is valid in…
Daniel
  • 41
  • 2
4
votes
1 answer

Is it literally impossible to build a SQL Server database project in Azure Data Studio on an M1 Mac?

I'm attempting to set myself up with Azure Data Studio on my new M1 Mac Mini, but the SQL Server database project I'm working on refuses to build. This is the (completely useless) error I'm getting: stdout:…
Dumas.DED
  • 466
  • 5
  • 17
4
votes
0 answers

Can I compare the contents of two databases in Azure Data Studio?

I have two databases and I want to do a data comparison between the two. In SSDT this can easily be achieved using the Data Compare feature, but I'm trying to move to using Azure Data Studio. I can see there's a schema comparison extension in Data…
Roo
  • 55
  • 1
  • 7
4
votes
1 answer

Azure Data Studio does not remember or persist connections

Newbie question: I have a group of notebooks that I'd like to connect to a single server and database in the same ADS session, structured like chapters in a book. For a single notebook, I can specify and connect to a database, and execute code…
Emanuel V
  • 143
  • 8
4
votes
0 answers

How do I change the colour of the results grid borders in Azure Data Studio?

There must be a way to do this, because switching between different themes changes the colour of the borders in the results grid. But I want to customise it for one of themes I'm currently using. (Which I know is possible based on this…
Rich
  • 125
  • 11
4
votes
0 answers

Azure Data Studio - not listing databases

When logged into Database Azure SQL Server from Azure Data Studio, doesn't list databases under connected server.
Sreedhar
  • 29,307
  • 34
  • 118
  • 188
4
votes
0 answers

Azure Data Studio - Prevent update without where clause

Is there any extension that would prevent executing an update query without the where clause?
Cătălin Rădoi
  • 1,804
  • 23
  • 43
4
votes
2 answers

How to change the default value of 1000 in "SELECT TOP 1000" in Azure Data Studio?

The default value in Azure Data Studio for SELECT TOP 1000 query from the table pop-up menu is 1000. Is there a way to change it? Searching all over the google shows you how to do that in Visual Studio, but not in Azure Data Studio. Thank you.
Dark Templar
  • 1,175
  • 13
  • 27
4
votes
5 answers

How to connect SQL Server on mac

I am using Azure Data Studio as software and it is impossible to connect SQL Server even with Windows Authentication. The process returns this error: But when i'm trying to connect via SQL login, program wants a username and password. I don't know…
Bob Reynolds
  • 71
  • 1
  • 1
  • 6
1
2
3
…
16 17