Database migrations help to keep database schema versioned, by documenting database changes in source control. But how should you test if those migrations are correct and will work against production consistently? In this article we are going to explain how we test database migrations using Flyway as our database migration tool and Spawn as our database provisioner.

Image for post
Image for post

Spawn is a cloud service provided by Redgate Foundry. It allows you to create ephemeral databases on demand that can be used for both development and for testing in CI pipelines.

Spawn components:

Spawn uses 2 components to work, and these should be familiar to anyone who has worked with Docker before. …

About

santiago arias

Software engineer

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store