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
10
questions with no upvoted or accepted answers
1
vote
0
answers
22
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
0
votes
0
answers
3
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
22
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
77
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,174
0
votes
0
answers
29
views
Azure Data Studio is not supporting any of the shortcuts in the documentation?
I am running Azure Data Studio on macOS. The simplest shortcut - to run the current query - is MIA. I tried F5, control-F5, command-f5, Option-F5 .. nothing happens. Is there any support for these ...
0
votes
0
answers
61
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
63
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
287
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
0
answers
107
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