Overview
What is Redgate Flyway?
Flyway, by Redgate, automates database deployments across teams and technologies. It is a database devops solution that is used to accelerate software delivery and ensure quality code.
Nice Migration tool for Java based solutions
Database migrations made easier
Flyway - Enabling DB-migrations-as-code
Highly recommended - Super easy to get started & simple as easy SQL commands.
Pricing
Community Edition
$0
Teams Edition
$3,000
Entry-level set up fee?
- No setup fee
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting/Integration Services
Product Demos
Flyway Store - Upload Ebay products to Pinterest Demo
SPRING BOOT FLYWAYDB MIGRATION DEMO TAMIL
Improve your database CI process with Flyway & Spawn
How we Used Flyway for Database Source Control | Lean TECHniques Inc
Product Details
- About
- Integrations
- Tech Details
What is Redgate Flyway?
Redgate Flyway Integrations
Redgate Flyway Technical Details
Deployment Types | Software as a Service (SaaS), Cloud, or Web-Based |
---|---|
Operating Systems | Unspecified |
Mobile Application | No |
Comparisons
Compare with
Reviews and Ratings
(12)Community Insights
- Business Problems Solved
- Pros
- Cons
- Recommendations
Flyway is an essential tool used for managing and applying DB migration patch scripts. It has proven to be invaluable for many users by automating the process of applying changes to the underlying database, saving time and effort. It is commonly utilized as part of automated test suites to verify the quality of patch scripts before merging them into the main branch, ensuring that changes in the PR are successfully applied.
With its focus on database version control, Flyway reduces the risk of data loss and allows for automatic backups. This feature has helped numerous users maintain the integrity and stability of their databases. Additionally, Flyway's compatibility with the Java ecosystem, specifically Maven and Gradle, provides seamless integration with existing workflows. The tool offers multiple functions/events to monitor the migration progress, making it a reliable choice for solutions based on Java programming language.
One notable use case for Flyway is in scenarios with frequent migrations and breaking changes. Users have found it particularly useful in detecting and resolving any issues or odd behaviors that may arise during these migrations. Moreover, Flyway's versatility allows it to be used in any environment, not just development, making it beneficial across various domains.
For those seeking advanced functionalities and enhanced collaboration, the Team edition of Flyway comes highly recommended. The ability to treat database objects as code on version control greatly impacts the software development cycle and enables teams to work efficiently together.
In summary, Flyway has become an indispensable tool for many users due to its automation capabilities, database version control features, compatibility with Java programming language, versatility in different environments, and advanced functionalities offered in its Team edition.
Helpful for managing database migration: Several users have found the product to be particularly helpful in managing database migration. This indicates that the product effectively facilitates the process of migrating databases from one environment to another.
Ability to manage DB migration patch scripts: Many reviewers appreciate the product's ability to manage DB migration patch scripts. This feature allows users to easily apply and test patch scripts, enhancing the overall efficiency of the database migration process.
Supports many databases: Numerous users have noted that the product supports a wide range of databases. This versatility makes it adaptable to different environments and allows users to work with various database systems.
Lack of User-Friendliness: Several users have found the GUI to be lacking in user-friendliness, suggesting that it could be more intuitive and easier to navigate. They feel that the current interface design requires improvements to enhance usability.
Difficulty with Patch Scripts on Blank Databases: Users have encountered difficulties when applying patch scripts on blank databases compared to those with existing data. This has resulted in potential migration failures even when all tests had passed. Some reviewers recommend streamlining the process for patching blank databases to avoid such issues.
Limited Configuration Options: Some users expressed a need for more flexibility and power in the configuration options of the software. They feel that the current settings available are too limited and restrict their ability to customize and optimize the software according to their specific requirements.
Based on user feedback, there are several recommendations for Flyway:
- Include Flyway in the tech stack to boost developer productivity.
- Use Flyway for basic tasks and highlight its easy integration with Spring.
- Improve rollback implementation to make it easier for developers.
Overall, users find Flyway to be a reliable and bug-free solution for database migration and versioning needs. They recommend using it to boost productivity and highlight its seamless integration with Spring. Additionally, they would like to see improvements in the rollback functionality to provide more control and flexibility.
Reviews
(1-4 of 4)Nice Migration tool for Java based solutions
We use Flyway in every single environment, in my opinion, is a good tool for every single scenario and is not restrained to development environments only. I do think that you will need at least the Team edition, to take advantage of database objects as code on version control. This feature has a huge impact on the software development cycle as it works as a kind of ORM tool with also the migration capabilities.
- Database Migration
- Database Migration Events
- Managing database objects as code objects in version control
- The Object Mapping should be available on commuinity edition
- More Programming Languages support
- Database Migration
- Database Migrations Events
- Automated database Migrations, no manual update on databases on each deployment to each environment.
- The migration events subscriptions allow the team to monitor productions deployments more carefully and detect errors before deploying breaking changes on a productive database
- Team onboarding is easier as any developer can get his local database working in no time thanks to database migration from scratch.
Database migrations made easier
- Supports many databases
- Community version uses Apache license
- Widely used, good community support
- Updating it causes problems, there have been unnecessary changes that wasted time
- Requires knowledge & studying so it's used properly
- Lots of options that might be difficult to understand for non technical people
- Free to use
- Makes deploying updates easier
- Supports many databases
- Updating environments takes less time & is more stable
- Less time is spent on maintenance tasks
- Can be executed by non-developers after implemented properly
Flyway - Enabling DB-migrations-as-code
- Manage DB migration patch scripts
- Apply DB migration patch scripts
- Test DB migration patch scripts
- Setup new DB instances, including on local env
- GUI could be more user friendly
- Applying patch scripts on a blank DB differs from on a DB with data, so the migration could still fail when all tests passed
- Configurations options could be more flexible / powerful
- Maven / Gradle integration
- Sanity check test with automated test suites
- Clear status report, error messages
- DB migration is fully automated
- DB migration is committed to source code, repeatable on all environments
- DB migration is fully integrated into development cycle
- Easy to manage Release Management.
- Version Control for Databases.
- Saved DevOps time.
- Improve the support documentations.
- Better dashboards and alerting.
- Maintaining Database Schema.
- Database Versioning.
- Made for CI/CD.
- Reduced our effort for release processes.
- Easy to setup - less than 5 minutes.
- Improve reliability of our databases.
- Easy backup and version control.