Activity overview
Latest activity by Peter Laws
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...
Where are Flyway CLI OSS artifacts
The paid for Flyway distributions are available through the typical Redgate ecosystem and can be accessed via the customer portal or flyway/installers. The Open Source Software artifacts are hosted...
Flyway has been compiled by a more recent version of the Java Runtime
This error occurs when there is a mismatch between the version of Java that Flyway was compiled with and the one locally available in the Java runtime environment (JRE).This issue is most likely to...
File is not recognized as a valid URI
This error occurs because the profiler tries to convert the source path from the PRDB file into a URI using the .Net System.Uri class. If the string is not a valid URI and cannot be converted into ...
Flyway DB object with value of '--No text is available'
Due to DB object being encrypted, the default behaviour of SQL Server is to return the comment.--No text is availableIf the user has insufficient permissions, granting the user the db_owner role wi...
Flyway baseline - invalid database objects
As a cross database tool, Flyway uses the term 'invalid objects' more broadly than some databases.The objective of this validation check is to avoid including potentially broken objects into the da...
The PDB file for this executable was not recognised as a valid URI
The validation check for supplied file are as follows, anything that doesn't match will return a warning.
A proper file URI, such as: file:///C:/path/to/file.cs
A valid HTTP/HTTPS URI, such as: ht...