Flyway AutoPilot - BackUp & Running
Published 02 September 2024
Flyway AutoPilot: Back Up and Running is a comprehensive sample project designed for teams that 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 lets you fully explore Flyway’s features and capabilities with minimal setup, tailored to your existing infrastructure.
Why Choose This Version?
This version is perfect for teams looking to test Flyway using their own database schema. It provides a complete setup with minimal effort required!
With this version, you can seamlessly integrate Flyway into your existing infrastructure, giving you the opportunity to test its features and value directly on your own databases. It offers a hands-on experience that highlights the full potential of Flyway in managing database changes across environments. Best of all, the entire process takes less than 20 minutes!
All the files you need to set up AutoPilot: Back Up and Running are hosted in a GitHub repository. Currently, it only supports SQL Server workflows, but watch this space as more will follow soon. This repository gives you the flexibility to use the prebuilt project with any Git tool you prefer. To keep things simple, we’ve also created step-by-step guides for using Flyway AutoPilot with GitHub and Azure DevOps—two of the most popular Git tools available.
New to GitHub or Azure DevOps?
No problem! This beginner’s guide is designed for everyone. And if you need a little extra help getting started, feel free to reach out to our team.
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