Activity overview
Latest activity by Peter Laws
It was an accidental oversight on our part and not the intended experience, as you noted 9.1.1 was released to correct the issue. / comments
Official comment
It was an accidental oversight on our part and not the intended experience, as you noted 9.1.1 was released to correct the issue.
Great advice from emmar00, the only thing I'd add is that Flyway Desktop has a dedicated tab for this scenario called ‘Update development’ so you can avoid needing to retarget databases. / comments
Official comment
Great advice from emmar00, the only thing I'd add is that Flyway Desktop has a dedicated tab for this scenario called ‘Update development’ so you can avoid needing to retarget databases.
Upgrading to at least V16.0.4.28477 will resolve this issue. / comments
Official comment
Upgrading to at least V16.0.4.28477 will resolve this issue.
Hello Benjamin, Thank you for raising the issue with us, I would anticipate a failure to access a warehouse to possibly be an account level permissions issue rather than the script itself. Are you using the same credentials in both instances please? If you're willing to share the code we can also attempt to replicate the issue. / comments
Official comment
Hello Benjamin,Thank you for raising the issue with us, I would anticipate a failure to access a warehouse to possibly be an account level permissions issue rather than the script itself.Are you us...
Hello Ian, Based on the difference it seems that AWS Keyspaces would need a dedicated implementation. That's not something Redgate is presently looking at, but the community might pick it up, it's worth sharing your interest there, other users may also share your interest. / comments
Official comment
Hello Ian,Based on the difference it seems that AWS Keyspaces would need a dedicated implementation. That's not something Redgate is presently looking at, but the community might pick it up, it's w...
Hello Michael, Repeatable scripts are executed alphabetically based on their description, so you can ensure their exact order. / comments
Official comment
Hello Michael,Repeatable scripts are executed alphabetically based on their description, so you can ensure their exact order.
This application has been built with SmartAssembly Personal Edition, and therefore cannot be distributed
When running an application, the following notification will occur if the software you are running was processed (obfuscated) with an unlicensed or trial version of our Smart Assembly software.If t...
Yes you have the right idea, the environments are separate from the global flyway scope allowing you to define them granularly and then plug those environments in to alter command targets. If XML is more familiar to you than TOML, think of them as nodes with values. Example TOML [flyway]
email = ""
token = ""
locations = ["filesystem:./migrations", "classpath:./jars"]
callbackLocations = ["filesystem:./migrations"]
table = "flyway_schema_history"
errorOverrides = ["S0001:0:I-"]
ignoreMigrationPatterns = ["*:pending"]
[environments.default]
url = "jdbc:sqlserver://localhost:1433"
user = "sa"
password = "*****"
[environments.UAT]
url = "jdbc:sqlserver://localhost:1434;integratedSecurity=true"
[environments.H2]
url = "jdbc:h2:./quickTest"
displayName = "H2" Then with my migrate command I can set -environment = default, UAT etc / comments
Official comment
Yes you have the right idea, the environments are separate from the global flyway scope allowing you to define them granularly and then plug those environments in to alter command targets.If XML is...
Why do I have a collation warning when I'm ignoring collation?
The primary function that the ignore option provides is reducing noise when comparing databases with different collations. This helps keep comparison results focused on meaningful differences rathe...
Unable to get local secret Flyway Desktop
You are seeing this error message in Flyway Desktop:Unable to get local secret Flyway Desktop d43d01-40e4-480c-aef6-c3344b531886
Caused by: Error reading secret: Element not found.It means the loc...