Flyway AutoPilot: Back Up and Running is a comprehensive sample project designed for teams who want to experience an end-to-end database development and automated deployment process using their own database schema. Unlike the lite version, which uses a predefined schema, this version allows you to fully explore Flyway’s features and capabilities on your existing infrastructure with minimal setup.

Why Choose This Version?

This version is ideal for teams looking to test Flyway using their own database schema, this provides the most comprehensive setup with minimal hands on required!

With this version, you can fully integrate Flyway into your existing infrastructure, allowing you to test its features and value on your own databases. It offers a deeper, hands-on experience, showing the true potential of Flyway in managing your database changes across environments.
This entire process can be done in less than 20 minutes!

Prerequisites

Before you begin, ensure you have the following:

1. SQL Server: Currently, this project supports SQL Server only. So having an instance available for use is essential! 
2. GitHub or Azure DevOps Account: Required to fork the AutoPilot project and manage your CI/CD pipeline.
3. Flyway Desktop: Installed and licensed for Flyway Enterprise. A free 28-day trial is available.
4. Basic Git and CI/CD Knowledge: Familiarity with GitHub or Azure DevOps and CI/CD concepts will be beneficial.

Get Extra Support: These projects come with an Exercise Book designed to help you become a Flyway pro!

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.

• 6.1 Automating With GitHub Actions

• 6.2 Automating with Azure DevOps

 7. Upskilling with the Flyway AP Exercise Book!

Now that everything is done, and you are enjoying Flyway, consider upskilling you and your team further with the Flyway AutoPilot Excercise Book

Why Use Flyway AutoPilot: Back Up and Running?

This version of Flyway AutoPilot is designed to give you a complete, realistic experience of database management with Flyway, tailored to your specific needs. By using your own database schema, you can see firsthand how Flyway can streamline your development and deployment processes, increase visibility, and reduce errors in production.

Whether you’re testing new database changes or rolling them out across multiple environments, Flyway AutoPilot: Back Up and Running equips you with the tools and knowledge to do so efficiently and effectively.