Apologies if this has already been asked, I did search the forum but couldn’t find anything directly related.
I’m fairly new to Octopus Deploy so I am still not completely familiar with it’s capabilities.
Within our Octopus Deploy process we have a step to deploy database which runs a DbScripts nuget package.
I would like to know if it is at all possible for Octopus Deploy to run certain scripts based on what environment level it is deploying to.
For instance, we have a script to insert some configuration values into a sql table. These values need to be different based on whether they are in Development, QA, & Production.
Is it possible for Octopus Deploy to recognize what environment it is deploying to and then do some kind of variable substitution?