Autopilot for Redgate Flyway is a suite of pre-configured sample projects designed to help you and your team quickly experience the power of database version control and automated deployments. Whether you're just getting started or looking to integrate your own schema into a CI/CD pipeline, Autopilot provides a hands-on, guided learning experience.

Why Autopilot for Redgate Flyway?

With Autopilot, you can:
✅ See the value of Flyway in less than 20 minutes
✅ Manage database changes with industry-standard tooling
✅ Streamline a POC in your environment with minimal setup
✅ Upskill your team and prepare for scalable deployments

Which version should you choose?

We recommend starting with Autopilot for Redgate Flyway - FastTrack and using our sample databases to experience the entire end-to-end process.  Afterwards, you can test your own schema with Backup & Running or explore a State-Based approach with Redgate   Here's what each version offers:

1. Autopilot for Redgate Flyway - FastTrack (Recommended)

This version is ideal for most teams and provides a fully pre-configured experience with minimal setup. If you're new to Flyway or just want to see its value quickly, this is the best place to start.

💡 Why FastTrack?

✔️ Ready-to-use sample databases
✔️ Pre-configured CI/CD pipelines
✔️ Built-in migration scripts and schema change tracking

🔧 Prerequisites: Basic familiarity with GitHub or Azure DevOps, and SQL Server or Postgres (currently supported)

📂 Pre-Configured Flyway Project

📚 Learning Support: Redgate University Course & Self-paced exercises (Quests)

👉 Get Started with FastTrack

2. Autopilot for Redgate Flyway - Backup & Running (For Complex Databases)

If your team has an existing, potentially complex database schema and wants to test Flyway on your infrastructure, this version is designed for you.

💡 Why Backup & Running?

✔️ Supports your existing schema
✔️ Pre-configured CI/CD pipelines
✔️ Advanced deployment strategies

🔧 Prerequisites: Basic familiarity with GitHub or Azure DevOps, and SQL Server (currently supported)

📂 Pre-Configured Flyway Project

📚 Learning Support: Redgate University Course & Self-paced exercises (Quests)

👉 Get Started with Backup & Running

3. Autopilot for Redgate Flyway  - State Based (For Simpler Workflows)

This version offers a streamlined State-Based approach, making it easier for smaller teams or less complex databases. 

💡 Why State Based?
✔️ The source of truth is a schema model
✔️ Flyway automatically generates deployment scripts at deployment time by comparing the schema model to the target environment.
✔️ Pre-configured CI/CD pipelines
✔️ Works well for teams without complex schema changes

🔧 Who is this for?
✅ Teams manually running deployments today.
✅ Teams using an automated CI/CD pipeline, but with simple schema changes
✅ Teams that need a lightweight, easy-to-maintain deployment process.
⚠️ Not ideal for teams with complex schema transformations—consider the FastTrack approach instead.

🔧 Prerequisites: Basic familiarity with GitHub or Azure DevOps, and SQL Server (Currently Supported, more to follow!)

📂 Pre-Configured Flyway Project

Ready to Dive In?

Start with FastTrack to experience Flyway to version and automate your database changes.