trying to get started with flyway on redshift

Question

I am trying to get started with flyway (for Redshift) and go through the commandline tutorial

flyway commandline tutorial

Unfortunately, whatever command I issue, like "flyway baseline" or "flyway migrate" (I created a simple create table script in the sql folder) results in the same error message:

ERROR: Unknown prefix for location (should be either filesystem: or classpath:): D:\Software\flyway-5.1.4\sql

Any idea what I might be doing wrong?

Thanks

Answer 1

You need to specify the filesystem: prefix in the locations argument like this:

flyway -locations=filesystem:D:/Software/flyway-5.1.4/sql ...