I am trying to set the SQLCmd variables based on the configuration (Debug / Release, etc.), but the Configuration drop-down menu is grayed out (see the figure below). For the Dev environment, I want the SQLCmd variable to be Stage, for the Release, Prod environment.
I cannot find an easy way to do this without going into properties. We have 9 projects and about 6 variables. Every time we do a circuit comparison, we must manually change the variables, and this is very tedious.
Our publishing scenarios are great for different environments, it's just a setup for comparing schemas, which makes it time consuming.
source share