You may also like

• 

  Article

  Creating Custom Regex Rules for Code Analysis in Flyway

  Every development team has its own coding standards. While Flyway provides built-in rules focused on security and data protection, teams quickly find they need additional checks to maintain SQL code quality and consistency across their projects. This article will walk through the ways of defining and testing custom rules, provides a starter pack of custom rules for common code smells, and then explains how to manage your rules efficiently as your rule library grows.

• 

  Article

  Maintaining Variants of a Database using Flyway Locations

  In this article, I'll explain why we often need to maintain variants of the same database, at a particular version. I'll demonstrate how useful variants can be for creating slightly modified installations of a database, for special uses, or even for the simple task of provisioning multiple copies of the same version. In doing so, I'll show how we can use Flyway locations to overcome problems that would otherwise require complicated solutions. Flyway can make the whole matter of maintaining database variants very easy.

• 

  Article

  Data Container Revisions, Resets and Graduations

  Redgate Test Data Manager allows developers to save each new version of a database as a data container revision. After making local development changes to the container, or running tests, they can instantly reset it to its starting revision. They can also load any previous revision and can even 'graduate' a revision to an image, providing a new baseline for ongoing team development. These techniques are especially effective when used in conjunction with Flyway, which automatically tracks the version of every copy of the database.

• 

  Article

  Implementing a Database Versioning System

  Database versioning brings more control to team-based database development and helps avoid many of the errors that often creep into database delivery. This article explains all the requirements of a semantic versioning system for databases, from specifying the format of the version numbers, to deciding where to store them and how to process and compare them.

• 

  Article

  New Flyway Migration Report

  As of version 9.17 of Flyway when running flyway migrate or flyway info a new report.html report will be written to your current folder. The migration report is designed to provide confidence that a Flyway deployment has run as expected, and in the case that it hasn’t, provides the necessary detail to help understand and

• 

  Lunch and learn

  Redgate Flyway Workshop: Lunch & Learn Amsterdam

  Live Lunch & Learn with Flyway experts (English and Dutch speaking) on how to streamline database deployments without compromising control or security. Discover real-world use cases from fast-paced development teams, learn practical tips to improve reliability and auditability across environments, and connect with like-minded professionals over lunch in Amsterdam.