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. 

Welcome to Flyway Autopilot for Oracle—an implementation-ready template that shows you how to build a real Flyway project using Oracle Data Pump backups. Unlike other Autopilot samples, this version is designed to reflect the realities of Oracle database development, where rebuilding from scratch isn’t always practical.

Instead of relying on raw SQL scripts to recreate your environments, this guide helps you baseline using Oracle Data Pump—a native and reliable way to capture the full structure of your schema for repeatable builds and CI/CD.

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

🎯 What This Walkthrough Covers

Flyway Autopilot for Oracle provides everything you need to get started with:

• ✅ A cloneable sample Flyway project designed for Oracle
• ✅ Support for provisioning from Data Pump backups
• ✅ Steps to capture schema and static data
• ✅ CI/CD templates for automated deployment
• ✅ Best practices for managing Oracle drift, migrations, and release pipelines

This guide is split into five key steps:

🧱 Step-by-Step Breakdown

🔗 Getting a Copy of the Autopilot Repository

Clone down the Oracle Autopilot project, which contains a Flyway Desktop workspace, sample CI/CD configuration, and support for backup provisioning. This is your starting point for working with Oracle in a Flyway-native way.

💾 Getting a Data Pump

Learn how to export a metadata-only Data Pump backup of your Oracle schema using the expdp tool. This backup acts as your baseline—used by Flyway to provision and rebuild environments safely.

🧩 Integrating the Data Pump with Flyway Autopilot

Set up Flyway Desktop to recognize and use your Data Pump for local builds and automated pipeline steps like shadow, check, and build. This ensures environments can be recreated using the Oracle-native format.

🛠️ Capturing Schema and Generating Migration Scripts

Use Flyway Desktop to version your Oracle schema and automatically generate migration scripts. Track new objects, table changes, view updates, and static reference data—all from a clean, provisioned baseline.

⚙️ Integrating with CI/CD Pipelines

Deploy with confidence by hooking up Flyway to your preferred CI/CD tool (e.g., Azure DevOps or GitHub Actions). Run reports, validate changes, and automate deployments across Dev, Test, and Prod.

💡 Why Use This Autopilot?

This is more than a sample—it’s a blueprint.
Flyway Autopilot for Oracle mirrors the setup used by real teams deploying to production with confidence. It embraces Oracle’s native tooling while giving you the full power of Flyway’s version control, validation, and automation.

🧭 Ready to Get Started?

Begin your journey by heading to Step 1: Get the Autopilot Repository
If you’re new to Git, Flyway Desktop or Databe DevOps as a whole, don’t worry—each step is fully guided.