Redgate Hub

Flyway (26)

Tracking development changes (26)

All databases

All levels

Flyway logo

Tracking Down Object Changes in Flyway Migration Files

The goal of this article is to help Flyway developers search their migration files to pinpoint exactly where a specific database object, like a table, view, or procedure, was created or changed. It introduces a PowerShell script that scans files in version order and returns the relevant DDL statements with… Read more

Flyway logo

Automated State-based Deployments in Flyway

Learn how Flyway's state-based deployments help teams coordinate database changes and automate deployments, reducing risk, without disrupting existing development workflows. This article explains how they work, where they fit best, and when it makes sense to move to a migration-based approach. Read more

Flyway logo

Scripting Databases with Flyway Enterprise CLI

This article will cover the basics of the Flyway generate command and how it can auto-generate several types of Flyway migration scripts. This includes versioned migrations that, after testing, can be used to deploy changes, and baseline migration and undo scripts that are useful for a range of development tasks. Read more

Flyway logo

Comparing Databases and Generating Schema Models with Flyway

This article explains how to compare databases and generate schema models using Flyway Enterprise CLI with PowerShell. It allows developers and DBAs to identify schema differences between environments and create schema models that capture the current state of a database, making it easier to track and review changes over time. Read more

Flyway logo

Finding Significant Differences in Flyway SQL Migration Code

This article demonstrates using PowerShell-based tokenization to compare two SQL migration files. It ignores non-functional changes like comments or formatting and pinpoints the first meaningful change in SQL logic, providing detailed feedback on its location and nature. Read more

Flyway logo

Defusing Flyway Validation Errors using Smarter Checksum Comparisons

This article provides a scripted SQL tokenizer script that quickly verifies whether a Flyway validation error is a real cause for concern, due to retrospective metadata changes, or just the result of a developer valiantly adding formatting and documentation to improve the code. If the changes are purely cosmetic, we… Read more

Flyway logo

Using ODBC in PowerShell Scripts and Callbacks

Flyway connects to database using JDBC, but when we're automating Flyway with PowerShell, we can't use JDBC directly to get access to the metadata we need to add useful reports and other functionality to Flyway's build and migration processes. This article demonstrates how to get what we need using ODBC… Read more

Flyway logo

Code Visibility: Browsing through Flyway Migration Files

If you can convert a SQL file to HTML, then you can inspect your Flyway migration files in a browser. This is especially useful if your SQL is color-coded with the same conventions as it was in your IDE. It is even better still if your browser can allow you… Read more

Flyway logo

Using Database Models and Flyway for Automating Routine Development tasks

Database models have all sorts of useful applications during Flyway development to help us automate those repetitive development tasks that otherwise slow down delivery. This article shows how models can help us automate mundane tasks such as generating a build script for any version of a database or deleting the… Read more

Flyway logo

Tracking Development Changes using Flyway and Database Models

A database model is a standard document that represents the logical design and structure of a database. If we save a model each time Flyway creates a new version of the database, then we can find out what's in each version, and get an overview of how that structure changed… Read more

Security and compliance

Database monitoring and observability

Database change management

Productivity and workflow automation

AI data readiness

Database modernization

Efficiency and cost optimization

Cloud migration and workload optimization

Redgate Flyway

Redgate Monitor

SQL Toolbelt Essentials

Redgate Hub

Tracking Down Object Changes in Flyway Migration Files

Automated State-based Deployments in Flyway

Scripting Databases with Flyway Enterprise CLI

Comparing Databases and Generating Schema Models with Flyway

Finding Significant Differences in Flyway SQL Migration Code

Defusing Flyway Validation Errors using Smarter Checksum Comparisons

Using ODBC in PowerShell Scripts and Callbacks

Code Visibility: Browsing through Flyway Migration Files

Using Database Models and Flyway for Automating Routine Development tasks

Tracking Development Changes using Flyway and Database Models

2026 State of the Database Landscape

Introduction to PostgreSQL for the data professional

Security and compliance

Database monitoring and observability

Database change management

Productivity and workflow automation

AI data readiness

Database modernization

Efficiency and cost optimization

Cloud migration and workload optimization

Redgate Flyway

Redgate Monitor

SQL Toolbelt Essentials

Cookies on red-gate.com