Flyway AutoPilot FastTrack is a sample project that allows you and your team to experience an end-to-end database development and automated deployment process with minimal setup. 

It is called Flyway AutoPilot FastTrack, as unlike its bigger brother Flyway AutoPilot: BackUp & Running it works by creating sample databases for you, allowing quicker testing! If you wish to use your own schema, head over too Flyway AutoPilot: BackUp & Running

Projects are currently hosted in GitHub for SQL Server and PostgreSQL. Regardless of whether you use GitHub for versioning and your pipeline, the concepts are identical for other tools such as Azure DevOps, GitLab, Octopus Deploy, etc.  Get in touch if you have any questions.

Flyway AutoPilot FastTrack provides: 

1. A SQL script to create ready-to-use sample databases
2. A pre-configured FlywayTrack project and pipeline in GitHub for continuous integration and automated deployments
3. Also included are
   1. already deployed migration scripts
   2. database changes saved to the project but yet to be reflected in migration scripts
   3. Reports generated in the CI/CD pipeline to provide more visibility and confidence

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

Why Choose This Version?

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 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 Azure DevOps
• 6.2 Automating with GitHub Actions

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.