microsoft / azuredatastudio

Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.
https://learn.microsoft.com/sql/azure-data-studio
MIT License
7.56k stars 898 forks source link

Support sqlcmd syntax within scripts #596

Closed AdamWilbur closed 4 years ago

AdamWilbur commented 6 years ago

Steps to Reproduce:

Open a file that uses sqlcmd syntax to execute another .sql file, like those commonly seen in pre and post deployment scripts in SSDT projects. For example:

:r .\SomeDirectory\MyFile.sql go

kevcunnane commented 6 years ago

There's a number of requests for this in the MSSQL repository too - https://github.com/Microsoft/vscode-mssql/issues/599. We should try to track both requests to help prioritize this.

tlagrone commented 5 years ago

1up

Swellenator commented 5 years ago

Definitely need this, I can't run the SQL Scripts output of SSDT project publish tasks.

hannahqin commented 4 years ago

SQLCMD mode is supported as of September 2019. https://github.com/microsoft/azuredatastudio/issues/2752