We have an Octopus deployment process with a database update step based on the dbup tool.
When deploying a specific release to an evironment the database update step makes a http request to an endpoint on our applicationserver passing the “Octopus.Release.Number” and “Octopus.Environment.Id” as parameters getting a list of SqlScripts as response. This works fine for all environments that have access to the internet to retrieve the list of SqlScripts.
Now however we have a new Environment that needs to be updated with a Offline package drop because of high security issues and no tentacle available. The target environment has no access to our application server to get the list of SqlScripts at install time. This means somehow the SqlScripts need to be part of the Offline package.
How could this be achieved?
So how can I add the SqlScripts to the Offline package at the time of creation so the SqlScript are accessible when the Offline package is executed in the target environment.
Thanks in advance,