Flyway State Based Migration should have Check Changes command added

[sidlittler]

Step template

Flyway State Based Migration

Step version

1

Octopus version

2026.1

Step template parameter inputs

Ran on Flyway Database Migrations
Package ID: #{Project.Package}
Flyway Command: Check Changes
Email Address: #{PAT_User}
Personal Access Token: #{PAT}
URL: #{project.database.connectionstring}
Auth Method: User/Pass
User: #{DB_USER}
Password: #{DB_PW}
Target: latest
OutofOrder: False
SkipExecutingMigrations: False
BaselineOnMigrate: False
check.BuildUrl: #{build.database.connectionString}
check.failonDrift: False
additional parameters: -cleanDisabled="false" -changesSource="schemaModel"

What happened

There isn't an option to producing a Changes report using schema model. I tried using the Flyway Database Migrations template (migrations-based) but it doesn't recognize the -changesSource parameter.
Thu, Jan 8th 2026 12:13:21 -07:00 Error ERROR: Failed to configure parameters: Thu, Jan 8th 2026 12:13:21 -07:00 Error Parameter: flyway.changesSource Thu, Jan 8th 2026 12:13:21 -07:00 Error Possible values: Thu, Jan 8th 2026 12:13:21 -07:00 Error - check.changesSource Thu, Jan 8th 2026 12:13:26 -07:00 Error NotSpecified: Execution of Flyway failed!

Reproduction steps

Because Flyway State Based template does not have check changes step, run the Flyway Database Migrations template with -changesSource="schemaModel"

More Information

https://documentation.red-gate.com/fd/check-changes-277578900.html

https://github.com/OctopusDeploy/Library/blob/master/step-templates/flyway-state-based-migration.json

[twerthi]

I have an update that I'd like you to try before I update the template. Contact your sales rep and tell them you need to get into contact with Shawn from Solutions Engineering.