Skip to main content

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

12 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
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) ...
Billy Bob's user avatar
  • 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 ...
ITried's user avatar
  • 111
0 votes
0 answers
9 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 ...
philipnye's user avatar
  • 163
0 votes
0 answers
175 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 ...
Sean's user avatar
  • 1
0 votes
0 answers
12 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?
herve's user avatar
  • 101
0 votes
0 answers
133 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 ...
Richard's user avatar
  • 101
0 votes
0 answers
112 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 ...
Bob Klimes's user avatar
  • 3,254
0 votes
0 answers
64 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 ...
WestCoastProjects's user avatar
0 votes
0 answers
92 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 ...
CB_Ron's user avatar
  • 291
0 votes
0 answers
122 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 ...
user avatar
0 votes
1 answer
475 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 ...
agentneru's user avatar
0 votes
0 answers
133 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 ...
zeeple's user avatar
  • 111