flyway

Article

The 'ShouldExecute' script configuration option in Flyway Teams simplifies 'conditional execution' of SQL migration files. This makes it easier to support multiple application versions from the same Flyway project, to deal with different cultural or legislative requirements. It also helps developers handle environmental differences between development, test and staging, such as the need to support multiple versions or releases of the RDBMS.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2021-12-10

Dry Runs for Database Migrations using Flyway Teams

by Additional Articles

Redgate

Vendors/3rd-party Products

Article

How Dry Run scripts work, and how they can be used to deliver a single-script release artifact to Staging, verify placeholder substitutions in SQL migration scripts, and simply team code reviews.

2021-12-06

Learn how to use Flyway for Automated Database Migrations

by Additional Articles

Redgate

Vendors/3rd-party Products

Article

Here's your one-stop-shop for Flyway learning resources, curated by Tony Davis. Check out this handy learning pathway for managing and automating database deployments, from version control, using Flyway.

2021-11-22

Getting In A State Using Flyway

by Additional Articles

Redgate

Vendors/3rd-party Products

Article

Flyway Teams baseline migration scripts are a simple and fast way to deploy new copies of a database, at a specific version, for testing work, or to create a new branch during development.

2021-11-17

Managing Database Documentation during Flyway-based Development

by Additional Articles

Redgate

Vendors/3rd-party Products

Article

Learn how to create and maintain a 'data dictionary' for your databases, in JSON format, which you can then use to add and update the table descriptions, whenever you build a new version using Flyway.

2021-11-10

Scripting with Flyway Teams and PowerShell

by Additional Articles

Redgate

Vendors/3rd-party Products

Article

During the development cycle, the mechanics of reliable delivery must not be allowed to dominate the design work. With script callbacks in Flyway Teams, many of the development tasks required during a database migration can happen automatically, producing reports, build scripts, code reviews, or documentation.

2021-11-05

Secrets of Flyway Teams Undo

by Additional Articles

Redgate

Vendors/3rd-party Products

Article

Flyway Teams has an Undo facility that enables you to roll back one or more migrations. This article demonstrates how it works and explains how Undo migrations make testing migration scripts easier and branch-based development simpler.

2021-11-01

Dealing with Failed SQL Migrations in MariaDB or MySQL

by Additional Articles

Redgate

Vendors/3rd-party Products

Article

Although it is easy to get started with Flyway, there are times when real-life can trip you up. Discover the fastest ways to restore the previous version of the database, to recover from a failed Flyway migration that leaves the database in an indeterminate state, and then how to adapt your database development process to avoid these problems.

2021-10-25

Flyway with MariaDB for Those of a Nervous Disposition

by Additional Articles

Redgate

Vendors/3rd-party Products

Article

This article from Phil Factor will get you up and running quickly with Flyway migrations on MariaDB or MySQL databases, from PowerShell.

2021-10-22

Why pay for open-source software?

by Additional Articles

Redgate

Vendors/3rd-party Products

Article

The very definition of open-source software means that developers can change the code, which means that exclusive, paid, licensing is not a part of the deal. In short, open-source is free. Free of licensing anyway. So, why might you choose to pay for an open-source software like Flyway? Grant Fritchey explores.

2021-09-27

flyway

Flyway Teams and the Problem of Database Variants

Dry Runs for Database Migrations using Flyway Teams

Learn how to use Flyway for Automated Database Migrations

Getting In A State Using Flyway

Managing Database Documentation during Flyway-based Development

Scripting with Flyway Teams and PowerShell

Secrets of Flyway Teams Undo

Dealing with Failed SQL Migrations in MariaDB or MySQL

Flyway with MariaDB for Those of a Nervous Disposition

Why pay for open-source software?

Blogs

T-SQL Tuesday #196 – Two risky career decisions I made

T-SQL Tuesday #192: What career risks have you taken?

T-SQL Tuesday #196: Taking Risks

Forums

XACT_ABORT being set to ON by web services

OPENQUERY Flexibility

A Full Shutdown

Question of the Day

OPENQUERY Flexibility