I am trying to customize default TFS build process by adding a step where a database is deployed using the database project. I followed [these steps][1] and the DB deployment works when the database name is hard code on the deploymanifest file on this step under InvokeProcess.
c. Set the Arguments property to "/a:Deploy /dd+ /dsp:Sql /manifest:DatabaseProjectName.deploymanifest". You must replace DatabaseProjectName with the name of the database project that you want to deploy.
My question is, how can I change DatabaseProjectName to a variable and have it assigned dynamically so this BuildProcessTemplate can be used by other database builds or if the project is branched within TFS? I tried using the $(DatabaseName) variable used in SQLCmdVars with the project properties, but it does not seem to resolve.