Flyway Desktop can automatically generate Undo scripts to help with rollbacks (Oracle, SQL Server,+)

Flyway Desktop tracks changes to a development database in a schema model on disk so it can be versioned controlled to understand how each object changes over time and provides better team collaboration.  When ready to deploy these changes, you can generate a Versioned migration script (a V script), which can be customized so you have full control over the deployment.  These V scripts can be manually deployed to other environments using the Migrations tab in Flyway Desktop or used as part of an automated CI/CD pipeline.

As of Flyway Desktop v5.13.4, you can decide if you want to generate a corresponding Undo migration script (a U script) every time you generate a V script.  The U script is responsible for undoing the effects of the versioned migration with the same number.  For example, V003.001__AddEmployeeAddress.sql would have a corresponding U003.001__RemoveEmployeeAddress.sql.  These U Scripts can be versioned controlled alongside the schema model and V scripts and can be tested manually or as part of an automated process.

This is an option because some teams prefer to roll forward fixes instead of rolling back.  It's very important to have a plan in place if something goes wrong.  Be extra careful if the scripts involve data changes. 

Learn more about generating undo migration scripts.

Flyway Desktop fully supports Oracle and SQL Server.  Our support for PostgreSQL is currently available as an early preview and we're researching what other databases to support.  Please let us know what databases you are work with.
Thank you!
Stephanie M. Herr    :-)
Product Manager Database DevOps

Comments

  • As of version 5.14.10.0 it's now possible to enable undo scripts via the UI.
    Within each project there is now a cog icon for configuration that will present this option.


    The former config file setup remains viable also.
    Kind regards
    Peter Laws | Redgate Software
    Have you visited our Help Center?

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file