Assigning database name to a variable in SSDT database publish script (automatically generated)

Question

All I would like to do is assign the name TestDatabase to the variable @test.

For some reason I can't seem to make it work. What is it that I could be missing here?

Here is my sample taken from the automatically generated script using visual studio.

 GO
 :setvar testdb "TestDatabase"

 --TSQL bit
 DECLARE @test nvarchar(10)
 set @test=$(testdb)  -- tried with $testdb, $[testdb]

Invalid column name 'testdb'. ** An error was encountered during execution of batch. Exiting.

Dmitrij Kultasev · Accepted Answer · 2015-03-20 14:20:54Z

2

 GO
 :setvar testdb "TestDatabase"

 --TSQL bit
 DECLARE @test nvarchar(10)
 set @test='$(testdb)'

answered Mar 20, 2015 at 14:20

Dmitrij Kultasev

5,8658 gold badges53 silver badges108 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

how come i forgot trying that bit?. Thank you very much @sidux. That was super quick.