The Role of the DBA Is Changing

For good or for ill, technology is constantly shifting and with it, the roles of those who manage that technology also shift. This is no different for a DBA than it is for a developer, an admin, or analyst. As new technology, like the adoption of the cloud, changes the role, people start to... Read more

Ajay Ahir

6 May 2021

Ajay Ahir

6 May 2021

Integrating Vault to secure Flyway parameters

Until now the only way to configure Flyway has been through plaintext configuration parameters such as in a Flyway configuration file, through the command-line or by setting environment variables. As your organizations and enterprises grow and more people interact with your processes you’ll inevitably want a way to secure as much information as possible,... Read more

Grant Fritchey

26 April 2021

Grant Fritchey

26 April 2021

Database Refresh and In-Flight Changes

An interesting question came up at the Redgate Summit a few weeks ago: What approach do you take to maintain database releases/changes in-flight that haven’t been applied to Production after them being wiped out after a database refresh? I have to assume that the person asking this question has not taken even the first... Read more

Ajay Ahir

21 April 2021

Ajay Ahir

21 April 2021

Customize validation rules with ignoreMigrationPatterns

Flyway can validate your migrations according to its own conventions, giving you the confidence you need to apply new migrations. However, as the lifetime of a project increases, there will inevitably be hotfixes, deleted migrations and other changes that break the conventions of Flyway’s validation. In these cases you need a way to tell... Read more

Chris Heppell

19 April 2021

Chris Heppell

19 April 2021

Why you should be testing Flyway migrations in CI

“It worked on my machine“. You’ve likely either heard this from a colleague or thought this yourself when a Flyway migration failed during a production deployment. The fact is that unfortunately, bad migrations slip through to the release process despite our best efforts. Thankfully, there are solutions to this – testing your Flyway migrations... Read more