TrustRadius: an HG Insights company

Redgate Flyway

Score9 out of 10

17 Reviews and Ratings

Get a Demo

What is Redgate Flyway?

Redgate Flyway extends DevOps practices to databases to speed up software delivery while keeping business-critical data safe. From version control to continuous delivery, Redgate Flyway helps enterprises build on application delivery processes to automate database development and deployments.

Categories & Use Cases

Media

Screenshot of Flyway Enterprise – auto-generation of migration scripts
Screenshot of Flyway Enterprise - reporting
Screenshot of Flyway Enterprise - drift detection

1 / 3

Screenshot of Flyway Enterprise – auto-generation of migration scripts

Reviews

What users are saying about Redgate Flyway.
View all reviews

Great database migration tool

Incentivized
Mary Stuart
Co-Founder in Information Technology at One Banana Solutions (1-10 employees employees)

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

Return on Investment

  • Avoided catastrophic database issues!

Usability

Other Software Used

Slack, DBeaver

Great migration tool for SQL code

Incentivized
Vlad ShcloverView profile
Principal Software Engineer in Engineering at Advisor360 (501-1000 employees employees)

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

Return on Investment

  • improving the quality and speed of deployments

Usability

Other Software Used

SQL Server Management Studio (SSMS), Microsoft Visual Studio, Microsoft Visual Studio Code

Redgate Flyway

Verified User
Engineer in Information Technology (1001-5000 employees employees)

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.

Return on Investment

  • I definitely think it do have positive impact to our company's database management.
  • We have 4 database environments and thus it is easy when we push the database to various environments.

Usability

Other Software Used

Redgate SQL Prompt, Redgate SQL Toolbelt Essentials

Nice Migration tool for Java based solutions

Incentivized
Arnaldo Corzo FerrerView profile
Lead Developer in Engineering at SOUTHWORKS (201-500 employees employees)

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

Most Important Features

  • Database Migration
  • Database Migrations Events

Return on Investment

  • 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.

Alternatives Considered

AWS Database Migration Service and Azure Migrate

Other Software Used

AWS Database Migration Service, Azure Migrate, FluentPro Migration Tools

Flyway - Enabling DB-migrations-as-code

Incentivized
Tung VuView profile
Senior Software Engineer in Engineering at Instaclustr (201-500 employees employees)

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

Most Important Features

  • Maven / Gradle integration
  • Sanity check test with automated test suites
  • Clear status report, error messages

Return on Investment

  • DB migration is fully automated
  • DB migration is committed to source code, repeatable on all environments
  • DB migration is fully integrated into development cycle

Other Software Used

Apache Maven, Gradle Build Tool (Open Source), PostgreSQL

Related Products

Products similar to Redgate Flyway that may also meet your needs.
All comparisons
Perforce Delphix
CompareLearn more
Liquibase
CompareLearn more