I have an Octopus configuration that deploys an app normally. The thing is that now we have to migrate the sql scripts in this same octopus configuration.
Currently we send the SQL scripts in the nuspec package along with the rest of the app files. We also have set up one step where we use Powershell to run Flyway, which is installed in the Octopus server. This step is run before the deployment itself.
The thing is that, since we have the SQL scripts in the nuspec package, these scripts end up being deployed along with the rest of the app files
My goal is to avoid sending these scripts to the different app servers
What’s the best solution to this?
Thanks a bunch