TrustRadius: an HG Insights company
Redgate Flyway Logo

Redgate Flyway Reviews and Ratings

Rating: 8.5 out of 10
Score
8.5 out of 10

Community insights

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.

Reviews

7 Reviews

Great database migration tool

Rating: 9 out of 10
Incentivized

Use Cases and Deployment Scope

I use Redgate Flyway as a database migration tool for my application.

Pros

  • Keeps track of migrations
  • Makes it really easy to version and review queries
  • Helps you understand what you have deployed, where super easily

Cons

  • The flow in and out of the SQL editor is a little crunky
  • I would like it to be easier to undo a migration

Likelihood to Recommend

It was so easy to get started and the product has be trustworthy and reliable throughout the time I've used it. Redgate Flyway are really proactive about reaching out to see if you need any support, and sending you lots of hints and tips to get started. I would definitely recommend this product to people who need a solid migration management tool.

Redgate Flyway

Rating: 9 out of 10

Use Cases and Deployment Scope

We use Redgate Flyway for our database management. So far I think this product is pretty good, sometimes we have bump, but in general it is a good product and our company likes it.

Pros

  • It protects our database so not everybody can randomly change the database.
  • We can have change history so we know who was the last person to modify the database.

Cons

  • For the script, especially for inserting a new row of data, I'd like to see to use if not exists, then insert, else just update.
  • When we run the script, it will error out if we use not exists for inserting new table rows.

Likelihood to Recommend

For our company, I think it is very suitable and we like it. We have used this product for over 1 year and it makes our database much manageable and we can have change history.

Vetted Review
Redgate Flyway
1 year of experience

Great migration tool for SQL code

Rating: 9 out of 10
Incentivized

Use Cases and Deployment Scope

We use Redgate Flyway for deployment of SQL code to QA and Prod environments using migration scripts. Redgate Flyway app is used to compare the our development database state to BitBucket's ReadyForRelease SQL project and to create migration script(s). Then we use dev ops validation pipelines to validate the migration scripts in our sandbox databases, and then we use deployment pipelines to deploy migrations to QA and Prod

Pros

  • comparison of dev db and bitbucket project code base
  • creation of migration scripts.
  • keeping the migration history in every db and knowing exactly the state of the db

Cons

  • cleaning up shadow db has to be done manually at times due to complex dependencies in our db

Likelihood to Recommend

Well suited for migration based deployments, especially when you deploy the same code to multiple prod environments. You are always sure of the environment's state

Nice Migration tool for Java based solutions

Rating: 9 out of 10
Incentivized

Use Cases and Deployment Scope

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.

Database migrations made easier

Rating: 6 out of 10
Incentivized

Use Cases and Deployment Scope

When new features are developed for applications they sometimes also require changes to the underlying database. These changes would be very difficult and time consuming to apply to all environments where application is running if had to done manually. Flyway can help to automatize this process and save time for employees.

Pros

  • Supports many databases
  • Community version uses Apache license
  • Widely used, good community support

Cons

  • 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

Likelihood to Recommend

If your application is running on many environments then some kind of automation for database migrations should be implemented. This will save time and trouble for employees and helps to manage migrations. However it must be understood that it is not a magical tool & should be studied properly so that it's limitations are understood & it will be used properly. Otherwise it might cause problems to the application.

Vetted Review
Redgate Flyway
4 years of experience

Flyway - Enabling DB-migrations-as-code

Rating: 8 out of 10
Incentivized

Use Cases and Deployment Scope

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.

Highly recommended - Super easy to get started & simple as easy SQL commands.

Rating: 9 out of 10
Incentivized

Use Cases and Deployment Scope

Database version control can be challenging, and we were facing issues while managing version controls for our database. Flyway helped us improve this significantly by reducing our risk of data loss and allowing automatic backups for the database. We had better peace of mind and reliability after we started using Flyway for our databases.

Pros

  • Easy to manage Release Management.
  • Version Control for Databases.
  • Saved DevOps time.

Cons

  • Improve the support documentations.
  • Better dashboards and alerting.

Likelihood to Recommend

We're thoroughly satisfied with Flyway. Even someone with basic SQL knowledge could use it without getting into tech complexity. It eased our release management and DevOps process while also increasing reliability. We use it across our testing, staging, and production environments. It is a perfect fit for our continuous delivery and zeroes downtime pipeline.

Vetted Review
Redgate Flyway
1 year of experience