Azure Database Migration service
An Azure service designed to help simplify, guide, and automate database migrations to Azure.
280 questions
2 answers
I have few confusion for SQL migration from OnPrem to Azure in between DMA/DMS/ Data studio & Azure Migrate
I have the below queries If Azure Migrate Readiness Report Recommend Onprem DB into Azure SQL Managed Instance & at onprem location, DMA was set up. In that case, is it required to set up Data Studio also at the on-prem location, as DMA does not…
asked 2024-01-14T08:24:18.5566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
answered 2024-01-16T09:41:44.89+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
ShaktiSingh-MSFT
13,751
Reputation points Microsoft Employee
1 answer
Azure Data Studio Notebook: Maximum Call Stack size Exceeded
I am using latest version of Azure Data Studio (1.47.0) to write notebooks and run queries against a sql database instance. When I try running two different cells I get the error: Maximum Call Stack size Exceeded. Is there a way to allow parallel…
asked 2024-01-02T09:40:29.8266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(48, 93%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPF%3C/text%3E%3C/svg%3E)
Pegoraro, Francesco
40
Reputation points
answered 2024-01-03T17:50:05.3666667+00:00
GeethaThatipatri-MSFT
27,717
Reputation points Microsoft Employee
5 answers
Connect to SQL Server Database Engine using SQL Server Authentication - error
Hi Microsoft Team, I am attempting to connect to our SQL Server 2019 database engine using SQL Server Management Studio (SSMS) 19.0.2, however I'm receiving the error message - Cannot connect to the server. When I use SQL Server Management Studio v18.10,…
asked 2023-04-28T22:05:45.2266667+00:00
Tahmid Bari
0
Reputation points
answered 2023-12-12T12:03:25.28+00:00
امنه محمد السيد على
0
Reputation points
1 answer
Login failed for user token-identified principal when trying to connect to my sql server from client
Seems like a straight forward installation from my azure portal. Created a sql service in AZURE. Downloaded Azure Data Studio on my client. Logged into my azure account. Tried to connect to the dB. "Login failed for user '
asked 2023-12-07T00:10:01.2633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 93%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETT%3C/text%3E%3C/svg%3E)
Tom Tully
20
Reputation points
answered 2023-12-07T05:05:38.12+00:00
ShaktiSingh-MSFT
13,751
Reputation points Microsoft Employee
1 answer
Best ptractices for remote employees to access Azure SQL from SSMS/Data Studio
So currently I have a test Azure SQL database setup. I setup up with public network access disabled. Today I changed it to "selected networks", and added my client's IP address so I could make sure that I could access the database from SSMS…
asked 2023-12-03T07:05:04.8233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(60.8, 90%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMB%3C/text%3E%3C/svg%3E)
Max Baroi
0
Reputation points
commented 2023-12-03T23:42:13.12+00:00
Andreas Baumgarten
97,566
Reputation points MVP
1 answer
One of the answers was accepted by the question author.
Add Folder to Workspace issue
Hello, I am using ADS on macOS. I have a few drives that I mount after I login and connect to VPN. Then I add those drives to Workspace. E.g. my drives are A, B and C. In ADS Explorer I added it and I see A, D and C. Recently I started to see instead of…
Office Mac
Office Mac
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Mac: A family of Apple personal computers that run the macOS operating system.
464 questions
Azure Data Studio
Azure Data Studio
A cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
99 questions
0 answers
Azure data studio will not bulk insert in UTF-8 encoding
Dear members, I am using the newest version of Azure Data Studio on Mac. I have tried bulk inserting UTF-8 encoded CSV file into a table. I have specified all columns as Varchar datatype, which is UTF-8 compatible. I also changed the collation of the…
asked 2023-11-26T19:00:32.81+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 75%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJA%3C/text%3E%3C/svg%3E)
Jan Alexandr Kopřiva
0
Reputation points
edited the question 2023-11-27T02:54:29.98+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 47%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
AjayBathini-MSFT
40
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Shell script document language in ADS
Hello, I am using ADS on Windows and Mac. I wanted to write something in bash. I was looking for for tool that could help me with syntax and etc. I found VS Code extension ShellChecker. I installed it but it does not work as expected. The issue is that…
1 answer
One of the answers was accepted by the question author.
How to get rid of 'shell' notification ?
Hello, I'm using ADS on MacBook. My default terminal is bash. Every time I start a Terminal ... I have this warning message: -- The default interactive shell is now zsh. To update your account to use zsh, please run chsh -s /bin/zsh. For more details,…
Office Mac
Office Mac
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Mac: A family of Apple personal computers that run the macOS operating system.
464 questions
Azure Data Studio
Azure Data Studio
A cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
99 questions
3 answers
One of the answers was accepted by the question author.
Configure ADS to open .pdf files automatically
Hello, I am using ADS on macOS. Sometimes I need to open .pdf files. My MacBook has Acrobat Reader and could handle these file types but my question is: could I configure ADS to open .pdf file automatically i.e. directly from Explorer ... like it opens…
asked 2023-10-14T19:55:23.7733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 94%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Susja
711
Reputation points
edited an answer 2023-11-09T11:00:58.1833333+00:00
ShaktiSingh-MSFT
13,751
Reputation points Microsoft Employee
1 answer
Locate file in ADS
Hello, I have not a problem to locate a content of the file in particular directory, but I need to locate the file itself. Sure, I could do it from terminal, but I'd like to locate it from Workspace. E.g. I am looking for foo.c and know the folder where…
asked 2023-11-02T16:57:18.9166667+00:00
Susja
711
Reputation points
commented 2023-11-07T13:51:09.0233333+00:00
Erin Stellato
481
Reputation points Microsoft Employee
1 answer
SQL object decoration theme
I have problem to understand object decoration in ADS related to SQL queries. E.g. I am starting to write a query and see the list of options that I could select. Each of it has some decoration. I assume it depends on type of object. Don't you have in…
1 answer
One of the answers was accepted by the question author.
Unable to add account in Azure Data Studio
Getting the below error while trying to add account in azure data studio error.jpg
asked 2023-08-25T16:32:30.4+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 61%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBB%3C/text%3E%3C/svg%3E)
Bittu Bhowmick
30
Reputation points
commented 2023-11-06T16:48:19.88+00:00
Erin Stellato
481
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Files decoration in Explorer in ADS
Hello, I am using Azure Data Studio. I noticed that in Explorer Tab it lists files and files have different colors and different icons in front of it. I would like to know what those icons and colors mean. e.g. .pdf files have obvious icon in front of…
1 answer
Locate file in ADS
Hi, Sounds like very primitive ... but I can't figure it out. I could find 'content' in the file using Explorer, but I need to locate the file itself. Sure, I could do it from terminal ... but I'd like to locate it from Workspace. It should be simple way…
asked 2023-11-02T16:54:49.7733333+00:00
Susja
711
Reputation points
answered 2023-11-02T18:24:20.7266667+00:00
Vahid Ghafarpour
18,370
Reputation points
1 answer
I am unable to see my azure sql migration extension in the azure data studio.
I am unable to see my azure SQL migration extension in my azure data studio. I have installed the Azure SQL Migration extension but unable to see in the data studio even I tried restarting the data studio. I am following this Microsoft document where i…
asked 2023-10-20T12:50:30.3533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(156.8, 38%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Surbhi Sharma
0
Reputation points
commented 2023-11-02T15:16:23.5066667+00:00
GeethaThatipatri-MSFT
27,717
Reputation points Microsoft Employee
1 answer
asked 2023-10-27T19:07:00.1166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(115.19999999999999, 37%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBO%3C/text%3E%3C/svg%3E)
Bảo Kha
0
Reputation points
commented 2023-10-31T16:25:33.8333333+00:00
GeethaThatipatri-MSFT
27,717
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
How to Change Keybinding button in ADS
Hello, On my Mac I use combination of 'cmd' + / to comment the line or block of lines. From my Mac I RDP to Windows computer and use ADS there as well. Hence it would be easier to use the same combination on 'remote' Windows machine as I use locally on…
1 answer
One of the answers was accepted by the question author.
Invalid column name in Visual Studio 2023 .cshtml file
been working on a file to help my sister and I have been stumped by this error which is stopping my code from running, all code is correct to my knowledge. The top image is the Razer code (SQL), and the bottom image is the table where i am trying to…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
5,174 questions
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,643 questions
Azure Data Studio
Azure Data Studio
A cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
99 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(188.79999999999998, 42%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
1 answer
How to fix the error 'running command dataExplorer.restore: s.getOptionsKey is not a function' that popus up while trying to restore a database using Azure Data Studio
This is the error that is displayed as soon as I try to restore a database on Data Studio. TIA!
asked 2023-10-25T07:11:25.8633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(118.4, 6%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIM%3C/text%3E%3C/svg%3E)
Ijaz M
206
Reputation points
answered 2023-10-25T08:53:16.63+00:00
ShaktiSingh-MSFT
13,751
Reputation points Microsoft Employee