TrustRadius Insights for Redgate Flyway are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.
Pros
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.
Loading Reviews List....
Redgate Flyway Reviews
2 Reviews
Engineering
Search is temporarily unavailable. Filters are still applied.
We use it as the primary tool for database migrations, especially for solutions based on Java programming language. It has an intuitive way to operate within the Java ecosystem (Maven and Gradle especially). It has multiple functions/events to keep watch on the migration progress, so it's very useful for solutions that had several migrations with breaking changes on it, in a small period of time, you can subscribe to each event along the migration and see the whole progress of it, and detect any problems or odd behaviors at any time. 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.
Pros
Database Migration
Database Migration Events
Managing database objects as code objects in version control
Cons
The Object Mapping should be available on commuinity edition
More Programming Languages support
Likelihood to Recommend
Database Migrations on Java-based solutions. It has one of the best integrations with it as a database migration tool, you can do it with the community edition (no pricing involved) and it works flawlessly with Maven and Gradle. It's not an expensive tool in order to use the next level of features and is worth the money. I would recommend reaching that edition level as the object mapping feature gets really handy. I would not recommend it for any Microsoft-based solution (.Net) as is not compatible at all based on my experience, this is a tool only worth it with Java applications.
We use Flyway to manage and apply DB migration patch scripts. It's also used as part of the automated test suites to verify that the changes in the PR are good and would be applied successfully. In other words, we use Flyway to test the patch scripts prepared by the engineers before merging them to main branch.
Pros
Manage DB migration patch scripts
Apply DB migration patch scripts
Test DB migration patch scripts
Setup new DB instances, including on local env
Cons
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
Likelihood to Recommend
With good Maven / Gradle integration, Flyway is very well suited to be part of a software project, from the very beginning to real production migration. The concepts are simple enough so all engineers in the team can use it at a basic level. The troubleshooting capabilities are reasonably good to troubleshoot migration issues. The ability to test out the migration patch scripts as part of the automated test suites on PR is also very great, although not perfect.