How do I get the database name in a Visual Studio script database project?

Question

I want to enable change tracking on my database using a Visual Studio database project.

Command

ALTER DATABASE ##database name##
SET CHANGE_TRACKING = ON
(CHANGE_RETENTION = 2 DAYS, AUTO_CLEANUP = ON)

but i cant process the format string to get the database name

+3

BenCr 07 Feb At 22:38

1 answer

John saunders · Accepted Answer · 2013-02-07T22:44:43+0000

Use the property $(DatabaseName)

. In the .sqlcmdvars file:

Target database name (set during deployment). Press F1 for more information.