Name: Redgate Flyway
Rating: 8.2 (13 reviews)
Author: Redgate

Help Desk

Web and Video Conferencing

Customer Support

Interactive Application Security Testing (IAST)

Development

Audit

Board Management

Business Intelligence (BI)

Collaboration

Enterprise Legal Management

Transportation & Logistics

Enterprise

Accounting

Anti-Money Laundering (AML)

Subscription Management

Finance and Accounting

Applicant Tracking

Corporate Learning Management

Employee Recognition

HR Management

Payroll

Succession Planning

Talent Intelligence

Talent Management

Workforce Analytics

Workforce Management

Human Resources

3D Printers

Application Delivery Controllers (ADC)

Bot Mitigation

Cloud Storage

Computerized Maintenance Management Systems (CMMS)

Data Mapping

Data Pipeline

Desktop Management

Desktop Outsourcing

Extended Detection and Response (XDR)

Fraud Detection

Hosted Virtual Desktop

IT Operations Analytics

Infrastructure-as-Code (IaC)

Integration Platform as a Service (iPaaS)

Internet of Things (IoT)

Interoperability

Network Performance Monitoring

Relational Database Management Systems

Smart Contracts

Tape Storage

Vulnerability Management

Workload Automation

Information Technology

A/B Testing

AI Writing Assistant Software

Ad Serving & Retargeting

Affiliate

All-in-One Marketing

Contact Management

Content Management

Contest Management

Digital Asset Management

Email Marketing

Gamification

Marketing Automation

Search Engine Marketing (SEM)

Social Media Management

Survey & Forms Building

Video Collaboration

Web Analytics

Marketing

Project Management

Transcription

Professional Services

Customer Relationship Management (CRM)

Intelligent Virtual Assistant

Multichannel Retail

Presales

Sales

Certificate Lifecycle Management

Database Security

GDPR Compliance

Security

Construction Accounting

Hotel Management

Loan Servicing

Vertical-Specific

Find top rated software and services based on in-depth reviews from verified users. 400+ software categories including PaaS, NoSQL, BI, HR, and more.

Liquibase

Redgate SQL Toolbelt Essentials

Redgate

HashiCorp Terraform

HashiCorp

dbt Labs

Azure DevOps Services

Microsoft

DBeaver

AWS Database Migration Service

Amazon AWS

erwin Data Modeler

Quest Software

Red Hat Ansible Automation Platform

Red Hat

Jenkins

GitHub

Azure DevOps Server

TeamCity

Oracle Database

Microsoft SQL Server

PostgreSQL

Octopus Deploy

GitLab

### Database Migration
Reviewers have expressed a mix of opinions regarding Redgate Flyway's database migration features. While some users appreciate the ease of scripting and monitoring capabilities for database migration, others have highlighted challenges such as the tedious process of migrating large codebases to Flyway and the lack of a migration rollback option. Additionally, concerns have been raised about potential issues with concurrent Flyway runs across multiple schemas and the difficulty in changing a migration after it has been checked in. Despite these drawbacks, many users find Flyway to be a reliable tool for managing database schema versions and automating database deployment processes.

### Schema Management
Reviewers consistently highlight Redgate Flyway's schema management as a standout feature, praising its ease of use and ability to handle database schema creation and updates efficiently. Users appreciate the support for various RDBMS and the simplicity of defining database changes through SQL files. The tool's versioning capabilities and the option to enable or disable features easily are also well-received. Despite some minor drawbacks like the lack of a migration rollback option, users find Redgate Flyway's schema management to be a reliable and valuable asset in database management tasks.

### SQL Script Management
Users have highlighted the convenience of Redgate Flyway in managing SQL scripts for database migration, emphasizing its automation and ease of debugging. However, some users have reported occasional issues with migration scripts being skipped during concurrent Flyway runs across multiple schemas. Despite this drawback, the majority of users find Redgate Flyway's SQL script management capabilities to be reliable and efficient for handling DDL and DML operations within their databases.

### Integration and Configuration
Users appreciate Redgate Flyway for its ability to easily integrate with various build tools and its user-friendly configuration options. The platform's support for plain SQL scripts and its compatibility with Java, Maven, and Gradle make integration a seamless process. Additionally, the detailed documentation and developer-oriented approach contribute to a positive experience when configuring and integrating Flyway into projects. Despite some minor drawbacks, such as limitations in using multiple heterogeneous applications with the same database, overall user sentiment leans towards the platform's strong integration and configuration capabilities.

### Environment Management
Users unanimously praise Redgate Flyway for its efficient management of environments. They appreciate the ease with which they can set up new databases for different environments, ensuring consistency and reliability across various stages of development. The ability to migrate databases effortlessly between environments and the compatibility with diverse SQL backends are highlighted as key strengths. Additionally, the automation capabilities provided by Flyway, such as integration with Jenkins pipelines for environment release, are lauded for streamlining the deployment process. The overall sentiment towards Redgate Flyway's environment management features is highly positive, with users finding it to be a valuable asset in their development workflows.

### Operations and Maintenance
Users consistently praise Redgate Flyway's streamlined operations and maintenance features, highlighting its efficiency in database migration and version control. The tool's ability to automate database changes and eliminate the need for manual intervention from the operations team has been a significant advantage for developers. Additionally, users appreciate the simplicity of configuration and the ease of maintaining different versions using Flyway. The platform's capability to handle schema creation for each microservice independently has also been well-received, reducing the burden of maintaining databases in separate repositories. Furthermore, the flexibility to migrate bulk amounts of static data across schemas with minimal configurations has enhanced scalability within distributed architectures. Flyway's integration with Jenkins pipeline for automating environment releases has further streamlined operations, making it a valuable asset for development teams.

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.

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.

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.

Based on user feedback, there are several recommendations for Flyway:

1. Include Flyway in the tech stack to boost developer productivity. 
2. Use Flyway for basic tasks and highlight its easy integration with Spring. 
3. 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.

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.

Community Edition

Teams Edition

Redgate's SQL Toolbelt Essentials includes industry-standard tools for SQL Server development & deployment, enabling users to include SQL Server databases in agile processes and enabilng developers to embed robust and scalable development practices.

DbVisualizer Free

DbVisualizer Pro with Basic support

DbVisualizer Pro with Premium support

DbVisualizer Pro with Basic support - Renewal

DbVisualizer Pro with Premium support - Renewal

DbVisualizer

Redgate Flyway

Database DevOps

How we Used Flyway for Database Source Control | Lean TECHniques Inc

Improve your database CI process with Flyway & Spawn

SPRING BOOT FLYWAYDB MIGRATION DEMO TAMIL

Flyway Store - Upload Ebay products to Pinterest Demo

Likelihood to Recommend

Azure Migrate

FluentPro Migration Tools

Lead Developer

Flyway 2022-11-30 09:00:20

Gradle Build Tool (Open Source)

Apache Maven

Senior Software Engineer

Flyway 2022-11-28 21:36:28

MySQL

Flyway 2022-11-29 02:14:02

WATI.io

Interakt.shop, dup

Userpilot

Flyway 2022-11-29 11:04:57

TrustRadius is a technology and business research firm based in Austin, Texas. The company is known as a review platform for verified B2B technology and software reviews through a proprietary algorithm and human verification.

TrustRadius

Java code

Easy to implement

Home

Database DevOps Software

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.

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.

AWS Database Migration Service and Azure Migrate

AWS Database Migration Service, Azure Migrate, FluentPro Migration Tools

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.

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

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

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.

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

MySQL, Red Hat Ansible Automation Platform, Microsoft SQL Server

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.

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.

Redgate Flyway

Overview

What is Redgate Flyway?