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

How to append a backup to an existing database in Azure Data Studio (SQL Server 2019)?

I tried to click on target database, which had a separate table (separate from all the tables stored in the .BAK backup file). How can I restore the backup on this target database? I tried restoring it, but the only way I see it's possible is to…
Aaradhya Chauhan
  • 3
  • 1
0
votes
0 answers

Azure Data Studio SqlException 0x80131904 on Ubuntu 22.10

I'm trying to use RedGate Azure Data Studio SQL Search Extension, but when I try to run the SQL Search Search in Active Connection command I get the following SqlException: ERROR: Exception while indexing MyProjects on localhost: DETAILS:…
user1737538
  • 497
  • 2
  • 7
  • 16
0
votes
0 answers

Missing Projects Icon from Activity Bar (Database Projects installed)

The issue: The projects icon simply disappeard from activity bar and I m not able to create projects from database anymore. History: After installed database projects and schema compare, I did some tasks and all was working fine, but I end up…
Jotace
  • 1
0
votes
0 answers

Azure Data Studio Run Python Notebook as a Job

I created a python notebook in Azure Data Studio and it is working as intended. I saw an article about being able to run notebooks as jobs with an extension. These notebook jobs create a PowerShell script that is executed as a sql agent job. It…
topher
  • 1
0
votes
1 answer

Tables No Longer Appear in Connections List - Azure Data Studio 1.41, Azure SQL Server Database

Specifically for my connection to an Azure SQL Server Database after upgrading to Azure Data Studio v1.41. When I connect into my Server/Database, and expand the Tables section from the left side menu, none of my tables appear. (Also my Views and…
MaKe
  • 1
  • 1
0
votes
0 answers

How to remove warning when I am modifying sql server table in Azure Data Studio?

Every time I change the structure of a sql-server table it shows me this warning when I use Azure-Data-Studio. I want to remove the warning and have it run directly. Thanks
Cesar Alvarado Diaz
  • 751
  • 7
  • 10
0
votes
1 answer

Publish fails with: dotnet build exited with code 0 (Azure Data Studio - SQL Database Projects extension)

I'm trying to Publish a database project with Azure Data Studio (ADS) to an Azure SQL Database. The build of the .sqlproj works fine with Visual Studio 2019 (Version 16.11.20) using SSDT, I always get the following output: Build started... ------…
kremity
  • 25
  • 6
0
votes
1 answer

Azure SQL Server Connection Issue

I'm attempting to connect to an azure sql server. My public IP was added to the IP whitelist, but when I try to connect to the server via Azure Data Studio it just keeps trying to connect with no error message (wheel keeps spinning). I tried using…
Will Hoynes
  • 1
0
votes
0 answers

how do i make my foreign key the actual ID instead of it being NULL?

I'm creating two tables and I would like to use UserID in User_info_table as a foreign key in the Trail_info_table, but it keeps showing as NULL. CREATE TABLE CW2.User_info_table ( UserID int IDENTITY PRIMARY KEY, User_name varchar(255), …
Morgan Trainor
  • 1
  • 1
0
votes
0 answers

How to add new user in Azure Data Studio Ubuntu 22.04?

I use Azure Data Studio: Version: 1.39.1 Commit: 7553f799e175f471b7590302dd65c997b838b29b Date: 2022-08-30T00:59:13.108Z VS Code: 1.62.0 Electron: 13.6.6 Chrome: 91.0.4472.164 Node.js: 14.16.0 V8: 9.1.269.39-electron.0 OS: Linux x64…
mark
  • 275
  • 4
  • 13
0
votes
0 answers

Azure Data Studio Authentication Error logging into Synapse Serverless Pool

Am trying to login into Synapse Serverless from Azure Data Studio with Azure Active Directory - Universal with MFA Support, but unable to login throws error on Account selection in browser "Unidentified error with azure authentication" Update:…
Sreedhar
  • 29,307
  • 34
  • 118
  • 188
0
votes
0 answers

Azure Data Studio select correct encoding

I have a problem with encoding in ADS. I set in all settings encoding on "UTF-8 with boom". And when I open a new query then ok "UTF-8 with boom" encoding is set but when I open some files with my T-sql store procedures then always azure data studio…
NewMe
  • 35
  • 1
  • 8
0
votes
1 answer

Azure Data Studio - fail to connection to login to server

I have create a container with docker: mssql is in docker with status up > docker run -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=Passw0rd!12" -p 1433:1433 -d mcr.microsoft.com/mssql/server:2019-latest I am trying to connect to SQL server on my…
Christine Nguyễn
  • 1
0
votes
1 answer

How can i view the SQL Agent in Azure Data Studio?

I have installed Azure Data Studio and the extension SQL Agent. I have also installed the Admin package extension as it seems to be under that. It does not appear when i click on Manage for the connected database. How can i get it to appear ?
Tracey
  • 81
  • 6
0
votes
1 answer

Not able to see the list of Databases in Server Navigation Panel while using Azure Data Studio

Please see the picture below: - I am not able to find the Database Folder which consists of all the database objects like Tables, Views etc. Instead I am directly getting all the Database Objects without the Database Folder in my Azure Data Studio…
Swarnim Khosla
  • 117
  • 1
  • 10
1 2 3
…
16 17