Earlier versions of Flyway supported simpler schema migrations within a single CockroachDB node. Both Flyway and CockroachDB aim to be simple to use, and we’re delighted that the Cockroach Labs team have worked closely with us to enable Flyway to be just as robust and reliable in scenarios involving many distributed nodes where migrations need […] Read more

In Flyway 6.4.0 we introduced a new feature, support for wildcards in the locations. With this feature a new set of solutions to organizing your migration files has now become available. In this post we hope to detail some of them, to aid the users of Flyway in deciding the solution that best suits their environment. Wildcards […] Read more

In Flyway 6.3.0 we introduced a new feature. The ability to use the ${flyway:timestamp} placeholder (See Placeholders for more details). This placeholder will insert the current date in the format yyyy-MM-dd HH:mm:ss as its value. Now, this has some very obvious uses such as storing the date a migration was executed into your database. However, there is something more complex you […] Read more

Flyway 6.3.0 is out! This release contains new features and improvements over Flyway 6.2.0. Highlights The highlights of the features introduced since the 6.2.0 release include: New in Flyway 6.3.0 Add a loadDefaultConfigurationFiles method to the api to load flyway.conf files from the default locations Add working directory support to the clients that didn’t already have it Add support for […] Read more

Flyway 6.2.0 is out! This release contains new features and improvements over Flyway 6.1.0. Highlights The highlights of the 6.2.0 release include: Add -color CLI option to allow overriding the default colorization Add flyway.validateMigrationNaming option to fail validation if scripts that don’t match the naming pattern are found in one of the configured locations Create all schemas specified in flyway.schemas Add FLYWAY_DEFAULT_SCHEMA environment […] Read more

Flyway 6.1.0 is out! This release contains new features and improvements over Flyway 6.0.0. Highlights The highlights of the 6.1.0 release include: Manual transaction override Snowflake support Machine-readable output for the info command Default placeholders Environment variable substitution in config files You can find a detailed list of issues fixed in the release notes. Manual transaction override You can […] Read more

Once a year at Redgate we hold Down Tools Week. It’s our hack week, when we temporarily put aside our normal work and form ad-hoc teams to propose, vote on and tackle new problems. One is always a charity project, others are useful internal tools, prototype products and experiments which we might not otherwise try, and […] Read more

Flyway 6.0.0 is out! This is the first full release by Redgate, and contains many new features and improvements over Flyway 5.2.4. This version also adds more features and fixes on top of the previous beta releases. Highlights The highlights of the 6.0.0 release include: A brand new parser Firebird support Validation of migration encoding SELECT output is […] Read more

So Flyway has joined the Redgate stable… A quick word of introduction – I’m Julia Hayward, I’ve been a software engineer for 26 years, four of those at Redgate, and I’ll be looking after Flyway. This is my first blog on flywaydb.org, and after a week of learning my way around the whole of Flyway’s code, […] Read more

In early 2010 I was doing some work around deployment automation. As part of this effort, I decided to tackle the problem of rolling out database changes along with the application consistently across environments, I wanted a tool that could be tightly integrated with application deployment, worked with plain SQL, and was simple to use. […] Read more