Redgate Blog

Posts by

Stephanie Herr

12 December 2025

SQL Compare & SQL Data Compare v16: Introducing SQL Server 2025 Support, Enhanced Security & More

SQL Compare and SQL Data Compare v16 introduces SQL Server 2025 support and improved credential security. Plus, SSMS 22 integration is coming soon. Read more

27 November 2025

27 November 2025

New in Redgate Flyway Enterprise – Drift detection and rollbacks just got easier

In our latest Redgate Flyway Enterprise release, you can store a snapshot directly in the target database, making drift detection and rollback strategies easier and more reliable whether you’re using state-based or migrations-based deployments. It started with a late-night production deployment. The team had tested everything in their QA environment, but when the deployment... Read more

Stephanie Herr

26 September 2025

Stephanie Herr

26 September 2025

New in Flyway: Pre and post deployment scripts for state-based deployments via callbacks

Flyway provides a lot of flexibility for releasing database changes in a safe and repeatable manner. Earlier this year, we added the ability to automate state-based deployments. This means the structure of the database is defined in version control and Flyway handles updating a target database to match it. The Flyway comparison engine does... Read more

Stephanie Herr

18 July 2025

Stephanie Herr

18 July 2025

Flyway code analysis – These are a few of my favorite rules

Clean, consistent SQL code isn’t just a preference. It’s a pathway to healthier applications, faster debugging, and happier teams. Whether you’re onboarding new developers or optimizing legacy systems, having a clear set of standards can make all the difference. Flyway’s code analysis is a powerful ally in keeping your database code tidy and secure,... Read more

Stephanie Herr

11 July 2025

Stephanie Herr

11 July 2025

Flyway Autopilot – Let us be your guide

Have you heard of Flyway Autopilot? It’s a collection of pre-configured sample projects developed by our Solution Engineers to help you get started with Flyway. These projects allow you to quickly experience capturing database changes in version control and deploying those changes in a repeatable, reliable way. Flyway Autopilot is ✅ Ideal for evaluating... Read more

Stephanie Herr

3 April 2025

Stephanie Herr

3 April 2025

Change Reports are now available for State-based Deployments in Flyway

Change Reports show how many objects are added, modified, and deleted at a glance by comparing the desired state of the objects to a target database. You can also drill into each object and see the exact changes in a side-by-side difference view. Change Reports are useful for: Pre-deployment – Gives reviewers a quick... Read more

13 March 2025

13 March 2025

Preview features and upcoming changes in the next major version of Redgate Flyway

We’re excited to announce that users can opt-in/out of preview features that are under development directly in Flyway Desktop. There are currently three preview features that will be in the next major version of Flyway Desktop; a new connection dialog with options to provision databases, a full schema model view, and support for static... Read more

Stephanie Herr

10 January 2025

Stephanie Herr

10 January 2025

New Redgate Flyway Release – Automate Even More

Read on to learn about how you can automate even more things with Flyway like project setup and state-based deployments. We’ll share how you can get the latest version and things you need to know when upgrading. Read more

Redgate Flyway

automated database deployment

Redgate Flyway Enterprise

Stephanie Herr

24 May 2024

Stephanie Herr

24 May 2024

What’s new in Flyway? State-based deployments in Flyway

Historically, Flyway has been a migrations-based database deployment tool. It greatly improves database deployments by tracking what migration scripts have been executed against a target database and applying any pending migration scripts. Since Redgate acquired Flyway in 2019, we’ve been incorporating Redgate’s database comparison technology into the paid edition (Flyway Enterprise) so that users... Read more

Redgate Flyway

Redgate Flyway Enterprise

Stephanie Herr

7 March 2023

Stephanie Herr

7 March 2023

Automatically Tracking and Deploying Static Data in Flyway Enterprise

Static data is often required for the basic functioning of a database and any dependent applications. Therefore, it's vital that we can track this static data to understand how, when, and why it changed, and that we include any static data changes in our database deployments. Flyway Enterprise will now do both tasks automatically. Read more

Posts by Stephanie Herr

Posts by

Stephanie Herr