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"