There are currently two ways to get your copy of Flyway AutoPilot. If you wish to use GitHub and it's Actions deployment pipelines, follow the first guide below on using the template. If you wish to use Azure DevOps, skip to the next section below and import the repository into an ADO Project.

IMPORTANT: These repositories could hold database schemas. We recommend making them private and giving access to only authorized people.

Getting started with GitHub

The entire project, and all needed files/scripts are located inside one easy-to-copy GitHub repository. 

1. Go to Flyway AutoPilot FastTrack for SQL Server or the Flyway AutoPilot FastTrack for Postgres and make sure you are signed into GitHub in the top right.
   
   
2. Click Use this template. This means that you have your own copy, all of the files you need to get started, as well as your own GitHub Actions Pipeline. Steps may vary slightly depending on the choice of DBMS, but this should be clear.
   
   **Important:** Do not fork the repository. Instead, create a private repository using it as a template. This keeps it secure and away from the public eye.
   
   
3. Give this repository a name and set it to Private, allowing you to potentially move your own schema into it without it being public. Then click Create Repository.
   
   
   
4. Click on the green Code button and copy the URL under the HTTPS tab. You’ll need this to create a new project from version control in Flyway Desktop.
   

Next step: See Opening Repository in Flyway Desktop below.

Getting started with Azure DevOps (Instead of GitHub)

1. Create a new Azure DevOps Project
   
   
   
2. Head to Repository > Import Repository.  The type will be Git.  The Clone URL will be https://github.com/red-gate/Flyway-AutoPilot-FastTrack for SQL Server or https://github.com/red-gate/Flyway-AutoPilot-PG for PostgreSQL.  Import the repository.
   
   
3. Your new Repository should look similar to this. Copy the main URL and move onto the next step below where we will open the repository in Flyway Desktop.
   

Opening Repository in Flyway Desktop

Tip: You should only have done one of the set of steps above, creating either a GitHub or an Azure Repository. 
Remember: These Repositories should be Private

Make sure you have Flyway Desktop installed.

1. Click the Open project… drop down and click Open from version control. Paste the copied URL from above, select an empty folder as the directory, and click Clone.
   →           
   
   
2. Select the `flyway.toml` file and click Open. In newer versions of Flyway Desktop, it will find your toml file automatically, so this may not be needed.
   
   
   
3. You will get an error about your database connection. This is because we haven’t created the databases yet. Click on the blue folder icon in the upper right to jump to the files on disk so we can create the necessary databases.

Once you have followed these steps, you will have successfully created your own repository with a Flyway Project in Flyway Desktop.

Next step > Provision your environments

Remember: If you need a trial key for Flyway Enterprise, you're in luck! You can easily get a free trial to explore the full range of features, onboard your team, or understand our offerings better via Flyway AutoPilot. Simply visit here to start your free trial today. If you have a contact at Redgate, you can also request a trial key for Flyway directly from them. Alternatively, you can reach out to the AutoPilot team at flywayap@red-gate.com for a free trial license.