Redgate Flyway

Welcome to Autopilot for Redgate Flyway: State Based

Designed to streamline database management, this approach simplifies deployments by using a schema model as the source of truth, ensuring your database always matches the latest desired state. This State-Based Autopilot eliminates the need for manually written migration scripts, making it an excellent choice for teams that want a fast and reliable deployment process without unnecessary complexity.

Instead of requiring your own schema, this project includes sample databases to help you efficiently test and refine your process before applying Flyway to your real-world environment. This ensures a smooth and scalable state-based deployment approach right from the start, embedded with industry best practices.

All necessary files for State-Based Autopilot are hosted in a GitHub repository, with support for both SQL Server and PostgreSQL. This repository provides everything you need to run a state-based deployment workflow, and it can be easily integrated into any Git tool you use.

To simplify things further, we've also created step-by-step guides for using State-Based Autopilot with both GitHub and Azure DevOps—two of the most popular Git platforms today!

Even if you're new to GitHub or Azure DevOps, don't worry—this guide is designed for beginners. However, if you’d like additional support before getting started, feel free to Get in touch.

What’s Included?

✅ A fully pre-configured Flyway project: Perfectly tweaked and ready to go
✅ Automated deployment scripts: Dynamically generate deployment scripts right first time (Whether through a desktop tool or automated using CI/CD)
✅ Pre-configured YAML Deployment Pipelines: Ready for GitHub & Azure DevOps (ADO)
✅ Reports & schema comparison insights: Get full visibility into what changes before deploying

Get Started

This guide will walk you through the following steps to set up and use Flyway Autopilot: Back Up and Running. For ease of access, we have split our documentation into sub-pages, see below:

1. Pre-Reqs

Learn more about the project, its prerequisites, and how it can benefit your team.

2. Getting Your Repository Ready

Start by setting up your repository on GitHub or Azure DevOps. We'll guide you through forking the project and configuring your environment.

3. Provisioning Your Databases

Use our provided SQL scripts to create ready-to-use sample databases from your schema backup.

4. Capturing Schema

Learn how to capture your database schema using Flyway Desktop and save it for version control.

5. Auto-Generate Scripts

Discover how to automatically generate migration scripts from your schema changes, ensuring a smooth deployment process.

6. Automating Deployments

Set up CI/CD pipelines with either GitHub Actions or Azure DevOps to automate your deployments.

Next Step > Pre-Requisites