Comments
Sort by recent activity
Hi Edd, Based on your debug output, it doesn't look like your supplied configuration file is being loaded. Please could you try explicitly pathing to it via the ConfigFiles parameter? Alternatively, you could duplicate the file to this directory: /opt/homebrew/Cellar/flyway/10.4.1/libexec/conf/flyway.conf I'm not certain it will be applicable here, but please be aware that flyway cannot load both conf and toml files, if both are present, it will only load toml. / comments
Hi Edd,Based on your debug output, it doesn't look like your supplied configuration file is being loaded.Please could you try explicitly pathing to it via the ConfigFiles parameter?Alternatively, y...
Are you able to write the flyway output to file from the API, so we can see what's going wrong when it fails please? / comments
Are you able to write the flyway output to file from the API, so we can see what's going wrong when it fails please?
Hello ms7, Thank you for the question, yes what you're attempting is completely possible. The scripts you're running, were they authored by Redgate tools or are of your own making please? Either is fine, it simply alters my considerations. Are you able to see what the repair action alters? If you need to recreate it, a before and after migration output of the schema history table should suffice. Once cavitate I would offer is the two Flyway engines (API & CLI) should be of roughly comparable versions, otherwise you could get mismatches behaviour. / comments
Hello ms7,Thank you for the question, yes what you're attempting is completely possible.The scripts you're running, were they authored by Redgate tools or are of your own making please? Either is f...
Hello Huzzer, welcome! Please could you check if your project is set to ignore collation or not? The setting is located under comparison options. For additional context, there's more detail here https://documentation.red-gate.com/flyway/database-development-using-flyway-desktop/configuring-comparisons-and-script-generations/comparison-options/sql-server-comparison-options / comments
Hello Huzzer, welcome!Please could you check if your project is set to ignore collation or not?The setting is located under comparison options.For additional context, there's more detail here https...
Hello aremund, After reviewing the functionality and the minimal documentation regarding, it's been concluded that this legacy behaviour is rather antithetical to tooling's intent and should be deprecated in the near future as there are now much better and more reliable means with which to achieve the same result. This is detailed in greater depth here. https://documentation.red-gate.com/flyway/flyway-blog/deprecation-of-flyway-s-interactive-behavior I recognise this isn't what you asked and I apologise for that, I'm hopeful that the alternatives will be superior. Should you have any issues implementing the alternatives, please do reach out! / comments
Hello aremund,After reviewing the functionality and the minimal documentation regarding, it's been concluded that this legacy behaviour is rather antithetical to tooling's intent and should be depr...
Thank you for the added detail Alain, I've now replicated the issue and raised it for the developers to correct. I'll keep you posted. / comments
Thank you for the added detail Alain, I've now replicated the issue and raised it for the developers to correct.I'll keep you posted.
Merry Christmas to you too aremund, delighted to hear that flyway is working well for you (aside from this little blip). Please can you clarify, on the command line are calling the connection like this flyway migrate <url> <user> <password> or flyway migrate <url> and then expecting flyway to prompt you for credentials interactively? / comments
Merry Christmas to you too aremund, delighted to hear that flyway is working well for you (aside from this little blip).Please can you clarify, on the command line are calling the connection like t...
Hello DamianWise Thank you for the question. Presently no flyway doesn't do that. From a product standpoint, if we were to do that, it would likely be implemented in Flyway Desktop rather than the CLI as it inhabits more of a review and publish workflow, whereas the cli is principally focused on deployments. / comments
Hello DamianWise Thank you for the question. Presently no flyway doesn't do that.From a product standpoint, if we were to do that, it would likely be implemented in Flyway Desktop rather than the C...
That's fair, we're not unaware of the appeal of native sql files and their ease of use certainly counts for a lot. On the downside, this necessitates two separate conversion stages rather than one with the newer model and we're more rapidly diversifying db scripting now. We've had script authorship for SQL Server and Oracle for ~12 years, and we've added MySQL, Postgres and well on our way with Snowflake in the last 2 years. It makes a big difference to our ability to be agile. That said, if you do find some knock on effects to the architectural decision, please do let me know! / comments
That's fair, we're not unaware of the appeal of native sql files and their ease of use certainly counts for a lot.On the downside, this necessitates two separate conversion stages rather than one w...
Thank you for the question mohammad.hafizullah, Yes in Flyway both Postgres and MySQL use the .rgm format instead. / comments
Thank you for the question mohammad.hafizullah,Yes in Flyway both Postgres and MySQL use the .rgm format instead.