Menu
I'm confused, if I select the "Create a deployment script" option and 'deploy' the project, i get a SQL file that uses non-SQL syntax for variables like $database.
How can I execute that deployment script? I'm pretty sure SQL Server management Studio doesn't understand the syntax.
It seems to me the only way to actually deploy, is to swith the option to "Create a deployment script and deploy to the database"
354
Click Query > Connection > Connect to connect to the server that contains the database you want to access. Select the appropriate StarTeam Server database. Open the tuning script, by choosing File > Open > foldername\scriptname. Execute the script, by clicking the Execute button on the toolbar or by pressing F5.
Open SQL Server Management Studio > File > Open > File > Choose your . sql file (the one that contains your script) > Press Open > the file will be opened within SQL Server Management Studio, Now all what you need to do is to press Execute button.
In Visual Studio Code, press Ctrl+Shift+P (or F1) to open the Command Palette. Select MS SQL:Connect and choose Enter.
The script that is generated by Visual Studio is not a standard T-SQL script. It is a SQLCMD script. SQL Server Management Studio does allow you to execute SQLCMD scripts, but by default it is disabled. This link explains more details on SQLCMD mode and how to enable it.
82
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
