Object versioning and script generation in Flyway
Flyway Desktop is a brand new tool designed for database developers using Flyway, providing a simple GUI to surface capabilities available in your Flyway edition.
Our development team is currently hard at work improving the advanced capabilities in Flyway, such as allowing database developers to maintains a version controlled schema model and the ability to auto-generate migration scripts.
The new schema model allows for a version controllable object-level history to be maintained (tables, procedures, functions, etc.), and provides for a mechanism to keep your teams’ development environments in sync.
Migration scripts and undo scripts are automatically generated, removing an element of human error from your deployment process, while also allowing the flexibility to customize your SQL scripts as required.
We’d love to know what you think of these capabilities so if you would like to try this for yourself, why not joining our preview program by following the instructions here.