Deploying database changes
Published 29 July 2021
In v5, Redgate Change Control has been renamed to Flyway Desktop. Check out the latest documentation at https://documentation.red-gate.com/fd
Redgate Change Control is used to track changes to your development database and generate migration scripts.
Redgate Change Control projects may be deployed with the Flyway command line or Docker container.
For SQL Server and Oracle projects, Redgate Deploy enables you to bring additional functionality into your pipelines by utilizing the command line or Docker container for Redgate's industry-leading comparison engines.
With Flyway Teams and Redgate's Compare command lines, you may create rich pipelines complete with:
- Dry run scripts (flyway migrate /dryruns)
Have a record of the exact SQL that was executed on the target envrionments or use a manual intervention and approval step in your pipeline to review the SQL that will be executed on a target beforehand. - Change reports (compare the output from build to the target; see /Report and /ReportType: for SQL Server and Oracle)
These reports show at a glance how many objects will change and what the change is. This can be useful during manual intervention and approval steps in your pipeline to understand exactly how each object will change and give DBAs a better understanding of the changes to determine if more review is needed. - Drift reports (compare the target with what was last deployed to the target; see /Report and /ReportType: for SQL Server and Oracle)
These reports show if there is a change in the target environment that did not flow through the pipeline. - Rollback scripts (compare the target with the output of the build; see /Report and /ReportType: for SQL Server and Oracle)
This gives you a starting point to undo changes. If there's table or data manipulation involved, then you'll need to have better recovery plans in place. - Code analysis reports
Run static code anlaysis checks to catch issues early. Rules can be turned on or off and have different severity levels (warning or error).
Be sure to review the Example CI/CD Pipelines to see how these work.