Product articles Redgate Flyway

Simple Safeguards for PowerShell Scripting with Flyway

This article demonstrates simple techniques to security-check any processes that use Bash or PowerShell scripts to automate database tasks, when using Flyway. These checks help ensure a script is trusted, hasn't been tampered with since creation, and doesn't contain commands commonly used with malicious intent. They add a valuable layer of protection, without sacrificing the power and flexibility that makes Flyway so effective. Read more

Creating Custom Regex Rules for Code Analysis in Flyway

Every development team has its own coding standards. While Flyway provides built-in rules focused on security and data protection, teams quickly find they need additional checks to maintain SQL code quality and consistency across their projects. This article will walk through the ways of defining and testing custom rules, provides a starter pack of custom rules for common code smells, and then explains how to manage your rules efficiently as your rule library grows. Read more

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