Database deployment automation using Octopus and Redgate Deployment Suite for Oracle

Bob Walker shares his experience of transitioning from manual to automated deployments for Oracle databases, using a combination of TeamCity, Octopus Deploy, and Redgate's Oracle Toolset. He outlines the creation of a CI/CD pipeline that automates the deployment process, reducing the complexity and time associated with manual deployments. Walker details the setup process, including creating a source database, tying Oracle to source control, configuring a build server, and setting up Octopus Deploy to manage deployments. He emphasizes the importance of generating delta scripts and having human oversight to build trust in the deployment process. While acknowledging the pipeline's current limitations, Walker encourages further enhancements, aiming for more efficient and reliable database deployments in the future.