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 Flyway […] Read more

“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 in […] Read more

We’ve had some users ask recently about multi-schema deployments. There are a number of possible scenarios, some of which are supported naturally by Flyway and some not. This blog post summarises the current state of play on the matter, but we’re keen to make sure we cover popular use cases. If you have any feedback […] Read more

18 months ago, Flyway was acquired by Redgate. It’s been quite a ride since then and we thought we’d end 2020 with an update on what’s been happening with the world’s most popular open source migrations framework for database deployments. We’ve learned a lot, and I wanted to share that with you in this post. […] Read more

Have you ever wanted more customizable control over when your migrations are executed? In Flyway Teams Edition 7.3.0 we released the shouldExecute script configuration option which lets you achieve just that! What is the shouldExecute option? shouldExecute is a new script configuration option, and if you aren’t already familiar with this concept you can read about it here. With […] Read more

Flyway 7.3.0 is out! This release contains new features and improvements over Flyway 7.2.0. Highlights A placeholder for the full filename of a migration file Script config files can specify shouldExecute Retrying connections back off exponentially Dry Run output can be directed to AWS S3 or Google Cloud Storage You can find a detailed list of the […] Read more

Why and how you should automate database migrations The desire to release features faster and deliver value to customers sooner is prompting many IT teams to adopt DevOps and Agile practices. By automating parts of the development process where possible and working in shorter cycles to release small changes more often, those teams that do […] Read more

Flyway 7.1.0 is out! This release contains new features and improvements over Flyway 7.0.0. Highlights Support pgpass for authentication Allow for filtering info output by date or version Allow arbitrary script callbacks Allow number of lock retries to be configured You can find a detailed list of the changes in the release notes. Filtering info output Flyway […] Read more

As you’ve likely seen we recently released Flyway 7.0.0, containing a lot of new features (read more about what features are available in the blog post). One of the new features is the new Flyway Teams configuration parameter skipExecutingMigrations. This configuration parameter changes migrate to skip executing the contents of the migrations during a flyway migrate or flyway undo, instead just updating the […] Read more

Flyway 7.0.0 is out! It contains many new features and improvements over Flyway 6.5.7. This version also adds more features and fixes on top of the V7 beta release. Highlights More control over deployments with the new cherryPick and skipMigrationExecution options Run arbitrary scripts as versioned migrations – PowerShell, Bash, Python, and more Amazon S3 bucket support Azure Synapse support A new […] Read more