Published 06 February 2020
Redgate Change Automation is a command-line application that can be used as part of a CI/CD pipeline to automate the deployment of migration scripts. It enables you to build a safe, automated release process with the following capabilities:
- A detailed change report so DBAs can quickly understand what objects will be changed and how as part of each release
- PL/SQL Code Analysis to check that best practices are being followed and your naming conventions are being enforced
- It integrates with utPLSQL, an Open Source database unit testing framework that we sponsor. so you can run automated tests as part of your CI/CD process to make your release safer
- Drift detection to make releases safer and catch any changes that happen outside of your release process and address these
- Rollback support with pre-release schema snapshots that can be used with Schema Compare for Oracle to provide a quick starting point for rolling back a release or a specific change in a release
- Future roadmap - A dashboard to understand how frequently you are releasing and more. Contact us if you'd like to learn more about our future dashboard plans.
There are currently 3 ways to get Redgate Change Automation:
- Windows - use the Deployment Suite for Oracle installer
- Docker - Download the image from Dockerhub
- Linux - (Coming soon) direct download of the .zip archive (contact us if you need this sooner)
The Redgate Change Automation command line helps you build, test, prepare, and perform database releases. If you are working with existing databases in your downstream environments (Test, QA, Prod, etc.), then you'll first need to do a one-off task to set the baseline version on these downstream environments. See our command line reference for more details on how to use these.
Examples of how to integrate Redgate Change Automation into CI/CD pipelines (e.g. Jenkins, Azure DevOps, Team City, Octopus Deploy, and more) can be found here.