Product articles
Redgate Flyway

Getting Started with Flyway SQL Code Analysis Rules

Before you apply pending SQL migration scripts, Flyway can automatically check them for a range of code smells. The check -code command can perform a static code analysis on these scripts to check that they comply with a set of rules designed to encourage good coding practices. You can opt to use SQL Fluff, provide your own Regex rules, or use both. This article explains how Flyway's regex-based code checks work and how to start running checks on Flyway-managed databases. Read more

Boost Efficiency and Drive Innovation with Flyway Enterprise

Managing database changes is challenging. Whether developing databases or ensuring their smooth operation, database change management needs to be low-friction, reliable, and efficient. Flyway Enterprise excels at database version control and automation and empowers your team to focus on what truly matters. Streamlined Development and Testing For development teams, the pressure to deliver quickly is Read more

Unlock the full potential of database change management with Flyway Enterprise

With the growth in data and increasingly complex database estates, efficient and reliable database migrations are crucial for maintaining seamless operations and driving innovation. Powered by industry-leading database comparison technology, Flyway Enterprise de-risks and accelerates the delivery of database changes across teams and platforms, and can transform your database management processes. Why Flyway Enterprise? 1. Read more

Using JSON Output to Track and Log Flyway Migration Activity

Flyway's JSON output provides a lot of useful information about the migrations files, database, and version changes, in a format that automated processes can read and use. This article demonstrates how we can create a Flyway callback that uses this JSON output to automatically send simple, human-readable notifications of what happened during a migration, helping developers stay informed about version changes that could impact their work. Read more

Defusing Flyway Validation Errors using Smarter Checksum Comparisons

This article provides a scripted SQL tokenizer script that quickly verifies whether a Flyway validation error is a real cause for concern, due to retrospective metadata changes, or just the result of a developer valiantly adding formatting and documentation to improve the code. If the changes are purely cosmetic, we can safely run Flyway repair to resume normal migrations. Read more