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 (ADO), skip to the next section below and import the repository into an ADO Project.

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.
   

   Tip - If you don't see the 'Use this template' button, ensure you first login to GitHub

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

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.
   →    
   

   Tip - If your repo is private, which is the recommendation, ensure you use the correct URL when cloning. For example:

   Repo URL - https://github.com/MyAccountName/FlywayAutoPilot.git (Using this may fail through Flyway, as it cannot find the private repository)

   Updated Repo URL - https://MyAccountName@github.com/MyAccountName/FlywayAutoPilot.git (By adding my GitHub username before github.com, this helps GitHub ensure I first need to login as this user, before it searches for the repo)

   *If problems continue, simply clone down your repository outside of Flyway using your preferred GIT method. Then use the 'Open from disk' method above and select the Flyway.toml as shown in the step below.

2. Select the `flyway.toml` file and click Open. In newer versions of Flyway Desktop, it will find your toml file automatically, so this will not be needed.
   
   
   
3. Don't panic, this error is expected. This is simply because we haven’t created the databases to connect to yet. Therefore, 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