Batch Processing using Flyway
How to create a batch file that executes any number of database migration tasks across a range of servers and databases, using Flyway.
2021-04-21
flyway
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.
2021-04-05
Automating Migrations for Multiple Databases using Flyway
During development you need a fast, automated way to build multiple copies of a database on any development or test server, with each database at the right version. This article provides a PowerShell automation script for Flyway that will do the job.
2021-04-02
Using Flyway Output in PowerShell
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.
2021-04-01
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 show you how to run this check, using sp_RefreshSQLModule, and incorporate it into a Flyway "after" migration script.
2021-03-25
Getting Data In and Out of SQL Server Flyway Builds
Phil Factor provides SQL routines to extract data from and load data into a SQL Server database, using BCP, and then a PowerShell automation script that uses Flyway to automatically build a database, from scratch and then fill it with data, ready for testing.
2021-03-10
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.
2021-02-26
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 database with test data.
2021-02-12
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.
2021-02-03
Database version control: Getting started with Flyway
Flyway is a multi-platform, cross-database version control tool. Carlos Robles explains Flyway’s history and shows how it works.
2021-02-02
Blogs
Top 4 WordPress Shortcuts to Save You Time and Boost Productivity
By Rob Sewell
Work smarter, not harder.
Using Copilot to help me update SQL Saturday
By Steve Jones
An interesting AI experiment here with Copilot from GitHub in handling some code I...
Master SQL with This Free Course (141 Interactive Exercises Included)
SQL is essential for modern businesses and applications that rely on data. It's a...
Forums
New article
Comments posted to this topic are about the item New article
Monitoring Azure Blob Storage
Comments posted to this topic are about the item Monitoring Azure Blob Storage
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers