Flyway AutoPilot - BackUp & Running
Published 02 September 2024
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 FastTrack 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!
All the files you need to get AutoPilot Backup and Running setup are currently hosted in a repository in GitHub, only supporting SQL Server workflows for the time being. 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 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.
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.
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