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 for quicker testing! If you wish to use your own schema, head over too Flyway AutoPilot: BackUp & Running

All the files you'll need to get AutoPilot FastTrack setup are currently hosted in a repository in GitHub, with a version for both SQL Server and PostgreSQL. This repository and all the files within, will give you the flexibility to take this pre-baked project and use it in any GIT tool out there! However, to make things simple, the team here have created pre-made guides for using Flyway AutoPilot FastTrack with both GitHub and Azure DevOps (Two of the most popular Git tools available). 

If you're not familiar with GitHub or Azure DevOps, that's not a problem, this beginners guide is still for you! However, if you'd like a bit of additional support before you start, please feel free to Get in touch.

Flyway AutoPilot FastTrack provides: 

1. A SQL script to create ready-to-use sample databases
2. A pre-configured FlywayTrack project and pipeline in both GitHub & Azure DevOps (ADO) formats for continuous integration and automated deployments
3. Also included are
   1. Pre-created migration scripts
   2. Pre-setup Flyway Project Settings
   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 on install.
4. Basic Git and CI/CD Knowledge: Familiarity with GitHub or Azure DevOps and CI/CD concepts will be beneficial (Although not fundamental).

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