In Flyway documentation I found that it supports migration script not only in SQL format, but also as PowerShell, Bash, Python etc. formats (Flyway docs)
And found an example that it should be possible to use migrations like this:
V1__create_table.sql
V2__alter_table.sh
But testing it using flyway command line tool I see that Flyway always skips any other file extension except .sql
Here is my command:
flyway migrate info -url=jdbc:sqlserver:DB_URL -locations=filesystem:"/Users/blabla/repos/flyway” -user=“USERNAME” -password=“PASSWORD” -defaultSchema=“yes”t -table="flyway_schema_history" -cleanDisabled="true" -baselineOnMigrate="true" -baselineVersion="0.0.1"
AmI doing something wrong?
Flyway CLI version is Flyway OSS Edition 10.17.0 by Redgate