Questions tagged [azure-data-studio]
Azure Data Studio is a cross-platform database client from Microsoft that enables working with SQL Server, Azure SQL DB and SQL DW
25
questions
15
votes
2
answers
13k
views
Azure Data Studio - Intellisense does not detect tables, yet queries work. How do I fix this?
Okay. So I'm breaking some new ground and trying to get into Azure Data Studio. I'm having a problem with intellisense that seems to be a bug with Azure Data Studio but I'm not sure.
I have issues ...
- 169
6
votes
2
answers
17k
views
How to generate Entity Relationship (ER) Diagram of a on-premises database using Azure Data Studio (macOS)?
I found a similar question for SQL Server Management Studio. But I use latest Azure Data Studio on macOS. We use on-premises SQL Server (not Azure cloud).
How can I use Azure Data Studio to generate ...
- 2,558
4
votes
1
answer
931
views
Change expired user password on sql server from linux
I have got a colleague (software developer) working on Linux only. He connects to our SQL Server using a sql login with password. Occasionally the password expires and he has to choose a new one. Up ...
- 705
3
votes
1
answer
859
views
How to Parse a query in Azure Data Studio?
In Sql Server Management Studio, we can click a "Parse" button (or Ctrl+F5) to verify that a SQL statement is syntactically correct (without executing it).
How can I do it the same in Azure Data ...
- 147
2
votes
1
answer
2k
views
Azure Data Studio - intellisence do not see tables in schema other than dbo
Do you know any way to force intellisence in Azure Data Studio to find tables in custom schemas?
As you can see I have tables:
dbo.TableC
schemaA.TableB
When typing a query, only TableC is found by ...
- 121
2
votes
1
answer
3k
views
Azure Data studio - connection to server in the same network - Error: The received certificate has expired
I am trying to connect to SQL server on my network with Azure Data Studio, and I am getting error:
A connection was successfully established with the server, but then an error occurred during the ...
1
vote
2
answers
973
views
Alternative to SQL Server Management Studio and Azure Data Studio to initially change my password
Background
I'm having to connect to a customer's Microsoft SQL Server. I generally don't need to do much in databases besides your average SQL, so using the database features in IntelliJ IDEA have so ...
1
vote
0
answers
26
views
Is there a way Azure data studio to find and add local databases under a list automatically?
When I create a database locally in SSMS it does not show up automatically in ADS. I have to add it as a connection each time.
Generally I use SSMS but am trying to switch away (or just try for fun) ...
- 111
1
vote
0
answers
2k
views
Incorrect syntax near 'BULK' for bulk INSERT in Azure Data Studio
I am trying to bulk insert a large CSV file delimited by tabs. I am on a Mac, and executing queries on Azure Data Studio (formerly SQL Operations Studio), since SSMS is not available for Macs. Here is ...
- 111
1
vote
2
answers
4k
views
Does Azure Data Studio have a debug Menu or option to debug a stored procedure?
I installed SSMS 19 Preview 4 and it doesn't have a Debug Menu or Debugging option. I also learnt that SSMS V17 was the last version with that capability. Then I decided to try Azure Data Studio, but ...
- 21
0
votes
1
answer
3k
views
How to change results cell padding in Azure Data Studio
In Azure Data Studio, I am trying to change the padding on the cells in the results grid.
According to the settings page, this is editable in the settings.json:
However, when I navigate to that file ...
- 115
0
votes
1
answer
2k
views
Does SQLCMD "!!" command work in Azure Data Studio
In SQL Server Management Studio, it is possible to run batch commands when in SQLCMD mode, using the !! command. However, in Azure Data Studio, this does not seem to work (SQLCMD has been available in ...
0
votes
0
answers
11
views
Can I merge settings.json files in Azure Data Studio
I want to make a few changes to by settings.json file and use these changes on another installation.
Is there a way of merging a simplified version of settings.json (with only some changes) on another ...
- 2,869
0
votes
1
answer
21
views
What are the cellPadding values in Azure Data Studio
I’m trying to get used to Azure Data Studio after using SSMS for some time, and, so far, I think its interface is very unfinished.
I want to change the cell padding, which I didn’t like to begin with, ...
- 2,869
0
votes
0
answers
10
views
git hooks in Azure Data Studio
Is it possible to use git hooks in Azure Data Studio, for example to run a linter against my SQL code?
I can't find any description of it in the documentation. And I can't translate my Visual Studio ...
- 163
0
votes
0
answers
246
views
Azure Data Studio Database Project Failure When Applying Schema Compare
I'm using Azure Data Studio. I created a brand new project and updated it from the database. Made a very small change, and attempted to apply back to the database. I receive the error "The ...
- 1
0
votes
0
answers
14
views
Command palette to refresh tables' list
Is there a way, without using the mouse, in Azure Data Studio, with the command palette for example, to refresh the list of tables in a database?
- 101
0
votes
0
answers
164
views
How to see results as text or csv in Azure Data Studio without saving every time?
When running a query in Azure Data Studio I just want to see the results in text, not in a spreadsheet. Every time I have to click on the little icons in the right toolbar of the result set, then ...
- 101
0
votes
0
answers
131
views
Open file Azure Data Studio with CLI and connect
I am trying to start Azure Data Studio(1.46.1) from command line to open a file and connect to server and database. I can get it to work separately:
connect with new query
azuredatastudio --server ...
- 3,274
0
votes
0
answers
99
views
Azure Data Studio does not recognize schema changes until I close and reopen
I've been searching for an answer to this, but no one seems to be asking exactly this question. I created a Notebook in ADS to run a lengthy series of scripts to populate and then export from a temp ...
- 291
0
votes
0
answers
165
views
How to copy a database to another server with only some of the rows
Trying to copy a database from a hosted server to a local server for testing purposes and am trying to avoid exporting the whole database as a .bacpac file as there are some tables with tens, maybe ...
Maen Enma
0
votes
1
answer
553
views
Similar to how there exists a volatile table in Teradata SQL, how can I create a volatile table or something similar in Azure?
Seen below is the code of how I would create a volatile table when I was coding in Teradata. I liked it because it would be the same structure and format as a normal query, but it would make a ...
0
votes
1
answer
1k
views
Check constraint age 18< [closed]
Hello I need to create a constraint that chekc the user is 18< before listenning to certain songs but idk how... I tried this :
ALTER TABLE Historique_ecoute
DROP CONSTRAINT IF EXISTS ...
0
votes
0
answers
161
views
CommandLine for Exporting All MS SQL Tables to CSV
On my Mac, I have a docker container running an Ubuntu version of MS SQL. I have a DB running in it and I can access it via Azure Data Studio, and I can view each table individually and export it to ...
- 111
-2
votes
1
answer
60
views
Schema compare on production database [closed]
I often use Azure Data Studio's Schema Compare in lower environments like dev and uat, to get information about the schemas, before I commence with making changes and/or testing.
I need to compare the ...
- 97