Add post-deployment scripts to Oracle database deployments using Octopus Deploy, Jenkins, and Redgate

Bob Walker discusses the use of a model-based approach for database deployments with Redgate's tooling, emphasizing its ease of use for teams new to automated database deployments. This approach simplifies the process by comparing the desired state of a database with its current state and generating a delta script. However, it struggles with complex changes like renaming tables or moving columns, which require workarounds such as breaking deployments into multiple steps to ensure non-breaking changes. Walker illustrates the migration of a build server from TeamCity to Jenkins, detailing the configuration of Jenkins with Octopus Deploy for seamless deployments. He highlights the importance of post-deployment scripts in managing data transitions and suggests maintaining discipline in script management to avoid repetitive executions. The process is flexible enough to support blue/green deployment strategies by allowing databases to support the two most recent code versions. Walker shares insights on how this methodology has been successfully implemented in the past, enabling efficient data migrations and rapid environment setups, thus paving the way for advanced deployment strategies.