Redgate Blog

Posts by
Phil Factor
Phil Factor

Phil Factor (real name withheld to protect the guilty), aka Database Mole, has 30 years of experience with database-intensive applications. Despite having once been shouted at by a furious Bill Gates at an exhibition in the early 1980s, he has remained resolutely anonymous throughout his career. He is a regular contributor to <strong><a href="http://www.simple-talk.com/" target="_blank" rel="noopener">Simple Talk</a></strong> and <strong><a href="http://www.sqlservercentral.com/" target="_blank" rel="noopener">SQLServerCentral</a></strong>.

Phil Factor

Phil Factor

22 February 2022

Phil Factor

Phil Factor

22 February 2022

Flyway Gotchas

Explaining some of the 'gotchas' that can trip up the unwary Flyway user, and how to avoid them. One or two of these you'll encounter quickly, such as the case-sensitivity of parameters and arguments. Others, such as potential problems with undo scripts or running scripted callbacks, only when you are… Read more
Phil Factor

Phil Factor

16 February 2022

Phil Factor

Phil Factor

16 February 2022

Flyway Branching Walkthrough

We'll step through the process of using Flyway Teams to support database branching and merging, where the team split the development effort into isolated, task-based branches, and each branch has its own development database. Read more
Phil Factor

Phil Factor

4 February 2022

Phil Factor

Phil Factor

4 February 2022

Flyway Database Drift and How it Happens

Flyway's approach to database migrations is based on strict versioning, but there is a limit to what a single process can do to prevent 'drift'. This article explains how drift can happen, and why you also need source control and external processes that log changes, to prevent it. Read more
Phil Factor

Phil Factor

28 January 2022

Phil Factor

Phil Factor

28 January 2022

Moving to Team-Based Database Development with Flyway

Describing a route from a basic, 'managed' system of database development to use of branching and merging and CI, using Flyway. By taking these steps, you'll reduce development conflicts, lift testing restrictions, and the organization will have much more flexibility on the release of features and bugfixes. Read more
Phil Factor

Phil Factor

28 January 2022

Phil Factor

Phil Factor

28 January 2022

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… Read more

#getstarted