Search code examples
visual-studiossissql-server-data-tools

How to Prevent Project.params from Syncing when Saving

In Visual Studio SSDT, I have set up multiple Project Configurations, DEV, QA, PROD. Also, I have parameters set up for each configuration, so I can easily deploy to each environment with different parameters. However, when i edit a parameter's value and save, the new value is saved to the parameter for each configuration.

Here are the steps I followed: First I edit the value in aNewTestParameter enter image description here

Then, I save the Project.params file and switch to the QA Configuration. Notice it also has the DEV Value. enter image description here

How do I prevent this save from overwriting the values in my other configurations?

Solution

  • You will need to add the parameter to configurations (third button above the Name field in the screen-shots). Next, set these values accordingly in the "Manage Parameter Values" window that will follow. Upon doing this, the parameter values will correspond to whichever configuration is chosen in the configuration drop-down.