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
57
votes
7 answers

Azure data studio schema diagram?

I just recently downloaded Azure Data Studio with SQL Server Express since I'm using Linux . Is there an entity-relationship diagramming feature, kind of how SQL Server Management Studio has a database diagram feature? I want to visually see the…
badugi
  • 581
  • 1
  • 4
  • 5
31
votes
1 answer

How to Set Multiple Cursors in VSCode at Each Find Result

Today I wanted to edit all stops in a SQL INSERT that followed a Regex pattern. I realized that if I could use the multi cursor feature in Visual Studio Code I could make a ton of changes all at one time. For instance, in the following SQL INSERT…
Eric D. Johnson
  • 10,219
  • 9
  • 39
  • 46
14
votes
2 answers

Azure Data Studio - Setting SQL variables to be used as globals

In Azure Data Studio (ADS), is it possible to reuse SQL parameters from query to query? Not sure if I'm jumping out of the intended purpose of ADS but it would be really great if I could declare a set of variables in one code text (or anywhere) and…
Volearix
  • 1,573
  • 3
  • 23
  • 49
12
votes
1 answer

Using ODBC connection with Azure Data Studio

In order to connect to an IBM DB2 database, I am using DBeaver with an ODBC type of connection. But since I found Azure Data Studio very lightweight and portable, I want to ask if there is a way to connect to such databases because all I get is…
user10191234
  • 531
  • 1
  • 4
  • 24
10
votes
1 answer

Trying SQL Notebooks in Azure Data Studio but variables declared in one cell are not carrying to new cell

I'm trying to use SQL Notebooks similar to how I'm used to using Jupyter Notebooks for documenting some standard queries I use. However when I declare a table variable in one cell, the value isn't accessible in a new cell. I do this so I can…
reddi.tech
  • 2,183
  • 1
  • 16
  • 18
10
votes
2 answers

How do I export Server Group configurations?

How can I export to file my Server Group configurations in Azure Data Studio? I've created a Workspace file in my application solution that contains useful queries for troubleshooting, etc. I'd like to also include connection configurations for…
Craig Boland
  • 984
  • 1
  • 10
  • 18
10
votes
4 answers

How to connect Docker with Azure Data Studio?

I install docker container on mac(OS X) and install Microsoft SQL 2017 image file on docker.So, I try to connect docker with Azure Data Studio but didn't connect it. Can I connect docker with Azure Data Studio and How to configure it? Please help…
Jonzz
  • 101
  • 1
  • 1
  • 4
9
votes
2 answers

Token retrieval failed with an error In Azure Data Studio

Using the latest Azure Data Studio Version: 1.32.0 Attempting to access a database using Azure Active Directory MFA and am getting the error: Token retrieval failed with an error. Open developer tools to view the error How can I…
Mike Miller
  • 93
  • 2
  • 8
9
votes
1 answer

How to open new window of Azure data studio from terminal

I'm used to the command code . in visual studio code to open my project directory from terminal. Is there an equivalent command in Azure data studio to do the same ?
mehdi Ichkarrane
  • 396
  • 5
  • 10
9
votes
1 answer

Azure Data Studio set NULL in cell in edit mode

Is there any way to enter in a cell the DB NULL value in Microsoft Azure Data Studio (VSCode version of SQL Management Studio) while I'm in edit mode? I can't find any related. No context menu and no keyboard shortcut. Thanks
Yuri Morales
  • 2,351
  • 4
  • 25
  • 52
9
votes
3 answers

Script database with Azure Data Studio

https://learn.microsoft.com/en-us/sql/ssms/tutorials/media/scripting-ssms/scriptdb.png?view=sql-server-ver15 I would like to complete the step above with Azure Data Studio and I am not sure how to. I have previous experience with SQL Server but new…
user10462791
9
votes
1 answer

How to view execution plans in SQL Server on Linux

I have SQL Server installed on Linux. It was installed from Microsoft's repos as described here: https://learn.microsoft.com/en-us/sql/linux/quickstart-install-connect-ubuntu In MySql I used to write EXPLAIN in front of my query to see the execution…
Gherman
  • 6,768
  • 10
  • 48
  • 75
7
votes
1 answer

Print Azure Data Studio Notebook

Azure Data Studio. I love it. Wherever possible I am working in ADS instead of SSMS, gradually moving stand-alone SQL scripts to notebooks. Notebooks are so useful. Rich-text commenting of code using markdown, making a great way of documenting…
Stuart Steedman
  • 257
  • 2
  • 6
6
votes
1 answer

How can I copy data from an excel file into Azure DataStudio to create a table with it? (on a mac) thanks

I have a table I made in excel and I want to have the same table in my Azure DataStudio, how can I copy the data over? Thanks!
codingrainha
  • 119
  • 1
  • 11
6
votes
1 answer

Connect to Docker SQL Server 2017 Container on MAC OSX via SQL Operations Studio

I have the following SQL Server 2017 container up and running as per - https://learn.microsoft.com/en-us/sql/linux/quickstart-install-connect-docker CONTAINER ID IMAGE COMMAND CREATED …
WickedW
  • 2,331
  • 4
  • 24
  • 54
1
2 3
…
16 17