Product articles
Redgate Flyway
Tracking development changes

  • Flyway
  • Tracking development changes
  • Database Build tasks
  • PostgreSQL

Getting an Overview of Changes to a PostgreSQL Database using Flyway

How to use Flyway and PowerShell to automatically generate a database build script every time Flyway successfully created a new version. You can then investigate schema changes between versions simply by using a Diff tool to compare build scripts. Read more

  • Flyway
  • Tracking development changes
  • Team-based Development
  • Cross-RDBMS

Reporting on the Progress of a Flyway Database Development Project

This article demos a novel way to report on the progress of your Flyway development project. It provides both SQL and PowerShell versions of code that extracts information for each database version from the Flyway schema history table and then plots it in a Gantt chart. Read more

  • Flyway
  • Tracking development changes
  • Database Documentation
  • SQL Server

Reporting on Changes Made by Flyway Migration Scripts

Phil Factor demonstrates some PowerShell tasks that will produce a high-level overview, or narrative, of the main differences in the metadata between two versions of a database, during Flyway Teams migrations. Read more

  • Flyway
  • Tracking development changes
  • Callbacks and placeholders
  • Sqlite

A Flyway Teams Callback Script for Auditing SQL Migrations

Demonstrates a cross-database PowerShell callback script for reporting on and auditing Flyway migrations, telling you which scripts were used to create each version, when they were run, who ran them and more. Read more

  • Flyway
  • Tracking development changes
  • Team-based Development
  • Cross-RDBMS

Discovering What’s Changed by Flyway Migrations

A set of PowerShell cmdlets that will 'diff' two versions of a database and provide a high-level overview of the major database changes made by successive Flyway migrations. You can 'diff' a SQL Server database to the same one on PostgreSQL and find out which objects are the same and which are different. Read more

  • Flyway
  • Automation and workflow
  • Tracking development changes
  • Cross-RDBMS

Using Flyway JSON Output in PowerShell for Reporting

How to send Flyway logging and error output to JSON and consume it in PowerShell to produce ad-hoc database migrations reports, including any errors that occurred, the version of the database, runtimes for each migration script and more. Read more

Products

  • Flyway

Database types

  • Cross-RDBMS
  • MySQL
  • Oracle
  • PostgreSQL
  • SQL Server
  • Sqlite

Filter by level

Previous
  • 1
  • 2
  • 3