Redgate Change Automation (beta) is a command-line application that can be used as part of a CI/CD pipeline to automate the deployment of migration scripts for Oracle databases. 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
Redgate Change Automation has the following 4 commands
-
build - validates the migration scripts in the repo and runs code analysis
-
test - executes any utPLSQL tests
-
release-prepare - produces a targetted release artifact for a particular database version with change and drift reports
-
release-perform - executes the deployment script, if there is no drift
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, Team City, Octopus Deploy, and more) can be found
here.
There are currently 3 ways to get Redgate Change Automation:
If you have an initiative to automate your database releases in 2020, I’d love to talk with you about your plans and see if any of the above will help. You can email me directly at
stephanie.herr@red-gate.com.
Redgate Change Automation (beta) is a command-line application that can be used as part of a CI/CD pipeline to automate the deployment of migration scripts for Oracle databases. It enables you to build a safe, automated release process with the following capabilities:
Redgate Change Automation has the following 4 commands
There are currently 3 ways to get Redgate Change Automation: