We are using octopus deploy as Continuous delivery. We have already setup all web related configuration on octopus “Deploy Package Step” where we are deploying nuget package to octopus server and then it is deploying the application to multiple server nodes.
Now we are planning to implement database automation using DBUP on octopus server.We are creating a nuget package and using “Deploy.ps1” which contains the power shell command to execute the console exe application on server.
We are using "Deploy Package step " for the same we don’t want to install tentacles on DB server we want to use the same connection string which is already configured for our web application. We have just created DB user with DDL access(Create,Alter…).
As for our web environment we have multiple VM in environment so we don’t want to execute the script on multiple environment.
with “Deploy Package” step on octopus we are not getting any option where we can configure to execute the package on octopus server.
Please share your thoughts on the same.