Redgate Hub

All products

All topics

All databases

All levels

Flyway logo

Cherry-picking Migrations using Flyway

Describing the two main use cases for occasional "cherry picking" of Flyway database migration scripts: back-filling emergency production hotfixes to version control and managing parallel development streams. Read more

Flyway logo

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

Flyway logo

Checking for Missing Module References in a SQL Server Database Using Flyway

There are certain checks that need to be done after a database migration is complete. One good example of this is the check that a migration script, such as one that merges changes from a branch into main, doesn't cause 'invalid objects' (a.k.a. 'missing references') in your databases. I'll… Read more

SQL Doc logo

Documenting a SQL Server Data Catalog in HTML and Git Markdown

Dave Poole explains the need for high quality database documentation and then demonstrates how to document the SQL Server database for a data catalog, in both HTML and Git Markdown, using SQL Doc, SQL Data Catalog, PowerShell, and a few helper scripts to ensure consistency and correctness. Read more

Flyway logo

Flyway Baselines and Consolidations

Phil Factor demonstrates why we occasionally need to 'baseline' a database, when automating database deployments with Flyway, and a simple way of reducing the number of migration files that are required for a build. Read more

Flyway logo

Getting Data In and Out of SQL Server Flyway Builds

This article provides SQL "bulk copy" routines to extract data from and load it into a SQL Server database, rapidly, and demonstrates a way to automatically bulk insert the test data in a Flyway build, using a SQL callback. Read more

Flyway logo

Customizing Database Deployments using Flyway Callbacks and Placeholders

How to customize a database deployment process using Flyway, demonstrating how to incorporate tasks such stamping a version number into the latest database build, or writing to the SQL Server log. Read more

SQL Data Compare logo

Comparing and Syncing Data using SQL Data Compare Command Line

Robert Sheldon demonstrates how to start automating data comparisons between two databases, from the Windows command line or PowerShell. With a single command, you can easily compare and sync data such as test data sets, or static data used for reference or lookup purposes. Read more

Flyway logo

Getting Started with Flyway and SQL Server

Phil Factor explains how to get started with Flyway, as simply as possible, using PowerShell. This article provides a practice set of database automation scripts that will build a SQL Server database, and then update it, running a series of migrations scripts that make some schema alterations, and load the… Read more

Flyway logo

Managing database changes using Flyway: an Overview

This article describes the principles of using Flyway migrations to build a database from scripts, to a specified version, and to track, manage and apply all database changes. Read more

Previous Next

Sicherheit und Compliance

Datenbankmonitoring und Observability

Datenbankänderungsmanagement

Produktivität und Workflow-Automatisierung

KI-bereite Daten

Datenbankmodernisierung

Effizienz und Kostenoptimierung

Cloud-Migration und Workload-Optimierung

Redgate Flyway

Redgate Monitor

SQL Toolbelt Essentials

Redgate Test Data Manager

Redgate Hub

Cherry-picking Migrations using Flyway

Using Flyway JSON Output in PowerShell for Reporting

Checking for Missing Module References in a SQL Server Database Using Flyway

Documenting a SQL Server Data Catalog in HTML and Git Markdown

Flyway Baselines and Consolidations

Getting Data In and Out of SQL Server Flyway Builds

Customizing Database Deployments using Flyway Callbacks and Placeholders

Comparing and Syncing Data using SQL Data Compare Command Line

Getting Started with Flyway and SQL Server

Managing database changes using Flyway: an Overview

2025 Stand der Datenbank-Landschaft

Einführung in PostgreSQL für den Datenprofi

Sicherheit und Compliance

Datenbankmonitoring und Observability

Datenbankänderungsmanagement

Produktivität und Workflow-Automatisierung

KI-bereite Daten

Datenbankmodernisierung

Effizienz und Kostenoptimierung

Cloud-Migration und Workload-Optimierung

Redgate Flyway

Redgate Monitor

SQL Toolbelt Essentials

Redgate Test Data Manager

Cookies on red-gate.com