Today we tried to use CherryPick with Flyway CLI v9.15 (within Azure Devops) but received an error.

##[error]ERROR: Unknown configuration property: flyway.cherrypick

However, when we used the same option in Flyway Deskop (v
6.3.11 engine v9.17), we don't get the error and the migration is successful.  We tried several different variations of the CLI command by moving 'migrate' directly after the flyway command.

Any thoughts?  


DavidWNAZ
0

Comments

4 comments

  • DanC
    Hi @DavidWNAZ

    Would you be able to provide me with the command you're using so I can see the syntax?
    DanC
    0
  • DavidWNAZ
    I've redacted private info...but this is the full command.  Some clarification, we are using this command in an Azure Devops pipeline using an on-prem agent.

    flyway -baselineOnMigrate=true -outOfOrder="true" -configFiles="C:\****\flyway.conf" -locations="filesystem:C:\****\migrations" -user="*****" -password="***" -url="jdbc:sqlserver://????????:????;databaseName=****;encrypt=true;integratedSecurity=true;trustServerCertificate=true" -licenseKey=***** migrate -cherrypick="6" info -baselineVersion=1 -cleanDisabled=true -check.reportFilename="C:\Drift-And-Change-Report.html"
    DavidWNAZ
    0
  • DanC
    Hi @DavidWNAZ

    If the casing is correct, the issue here is you have "cherrypick" when it needs to be "cherryPick" as it's case sensitive for the parameters: https://documentation.red-gate.com/fd/cherry-pick-184127485.html
    DanC
    0
  • DavidWNAZ
    Thank you Dan!  That was it.  I was not aware that the options were case-sensitive.  I appreciate the help.
    DavidWNAZ
    0

Add comment

Please sign in to leave a comment.