Unix/ Cygwin-like extension in ADS

Question

Hello

I started to use ADS recently and I like it but one thing I am missing.

Quite often I have to switch from SQL running to Cygwin for some text analysis. I tried to use PowerShell terminal but it’s not as convenient as Cygwin-like syntax.

BTW … is ADS Terminal the same as PowerShell extension?

Hence my question: does ADS has some extensions or other alternatives for Unix like commands?

Thanks

Answer 1

Hi
Susja •,

Please find below inline response:

what is the difference between Terminal in ADS and PowerShell extension ? I mean ... when I open Terminal in ADS ... what Terminal it is? Isn't it PowerShell?

Azure Data Studio is built on top of Visual Studio Code and offers a lightweight, keyboard focused modern code workflow experience when working with SQL Server, Azure SQL Database, and Azure Synapse Analytics. Azure Data Studio makes the core experiences that you rely on every day simple and easy with built-in features such as multiple tab windows, a rich SQL editor, IntelliSense, keyword completion, code snippets & code navigation and source control integration (Git and TFS)). You can execute on-demand queries, view & save results as text, JSON, or Excel, edit data, organize & manage your favorite database connections, and browse database objects in a familiar object browsing experience.

Use your favorite command-line tools (for example, Bash, PowerShell, sqlcmd, bcp, psql, and ssh) in the Integrated Terminal window right within the Azure Data Studio user interface. Easily generate and execute CREATE and INSERT scripts for your database objects to create copies of your database for development or testing purposes. Boost your productivity with smart code snippets and rich graphical experiences that create new databases and database objects (such as tables, views, stored procedures, users, logins, roles, etc.) or update existing database objects. Use rich customizable dashboards to monitor and quickly troubleshoot performance bottlenecks in your databases on-premises, in Azure or any cloud.

SQL PowerShell is available today on the PowerShell gallery and you can use it on Windows to work with SQL Server running anywhere, including SQL on Linux. Offering the SQL PowerShell cmdlets on Linux & macOS is in the roadmap. To help prioritize, file a suggestion on GitHub

Thank you.

Answer 2

Hi
Susja •,

Welcome to Microsoft Q&A forum.

As I understand, you want Unix like command interface extension in Azure Data Studio.

Could you please try Azure CLI if this is useful for you case:

Let me know if any specific commands you want to execute so that we can help.

Thank you.