Now that your environments are set up and the necessary databases have been created, it's time to start working with your Flyway AutoPilot project. At this stage, you’re configured to make changes to the AutoPilotDev database, track those changes using Flyway Desktop, and prepare for automated deployments through Azure DevOps or GitHub Actions which we will cover in a later step.

This section will guide you through the process of using Flyway Desktop to capture any schema changes you make in the development database, saving those changes to the schema model, and ultimately using Flyway to generate versioned migration scripts.

Step 1: Refreshing Flyway Desktop and Capturing Changes

Once the databases are created, it’s crucial to synchronize Flyway Desktop with the current state of your AutoPilotDev database. This ensures that all objects in the database that haven’t yet been saved to the schema model are identified and ready for version control.

1. Refresh Flyway Desktop:

   • Open Flyway Desktop, head to the Schema Model tab and click Refresh if it does not start scanning automatically. This action scans your AutoPilotDev database and displays a list of all objects (tables, views, stored procedures, etc.) that have not yet been saved to the schema model.
   • The schema model represents the current CREATE DDL script for each object in your development database. It acts as a snapshot of your database structure, allowing you to track how it evolves over time and revert to previous versions if necessary.
     

2. Adjust Connection Details (If Needed):

   • If your databases weren’t created on the default localhost instance and port, you’ll need to update the connection details in Flyway Desktop.
   • To do this, click on Edit Development Database Connection in Flyway Desktop. Update the Server, Instance, and Port fields to match your environment, then click Save.
   • Ensuring the connection is correct allows Flyway to accurately capture any changes you make in the development database.
     

3. Make a Change and See the Results:

   • Now that Flyway Desktop is connected to your AutoPilotDev database, try making a change. For example, create a new table in the database.
   • After making the change, click Refresh in Flyway Desktop again. You should see the new table listed among the changes that Flyway has detected.
     

This step completes the initial synchronization of your development environment. You are now ready to capture any changes you make in the AutoPilotDev database and save them into your schema model.
Step 2: Saving Your Changes to the Schema Model

With the changes detected by Flyway Desktop, the next step is to save these changes to your schema model. This process involves selecting the changes you’ve made and committing them to your Flyway project. Doing so ensures that all modifications are tracked in version control, allowing you to manage your database schema as part of your overall project.

1. Select and Save Changes:

   • In Flyway Desktop, check the box next to the change you just made (e.g., the new table you created).
   • Click Save to Project. This action saves the CREATE DDL for the object to the schema model on disk.
     

2. Commit to Version Control:

   • After saving the changes to the schema model, commit these changes to your Git repository. This ensures that your schema model is versioned, enabling you to track changes over time and collaborate with your team more effectively.

What’s Next?

With your changes saved to the schema model and committed to version control, your Flyway AutoPilot project is now ready for the final step: generating versioned migration scripts and setting up automated deployments through Azure DevOps or GitHub Actions. This final stage will complete your continuous integration and deployment pipeline, allowing you to automatically deploy database changes across environments with confidence.