Comments
Sort by recent activity
Hello ecantin, It looks like you're setting it correctly, just that the host directory doesn't allow for what you're trying to do. The error is essentially saying change the rights or move it somewhere else that has the required rights. / comments
Hello ecantin,It looks like you're setting it correctly, just that the host directory doesn't allow for what you're trying to do. The error is essentially saying change the rights or move it somewh...
I've spoken to the developers and their initial assessment is that it would necessitate a sizable architectural change to accommodate. Presently there hasn't been much demand for this functionality, however that doesn't mean it isn't wanted, people might just not have asked. What I'd recommend is head to the feature request forum (below) as that will provide a much better platform for your idea and more easily enable others to show their support if they too would appreciate this functionality. https://redgate.uservoice.com/forums/sql-compare Thank you for sharing your ideas Guenter / comments
I've spoken to the developers and their initial assessment is that it would necessitate a sizable architectural change to accommodate. Presently there hasn't been much demand for this functionality...
It greatly does, thank you. While we do have support for cross database dependencies, unless these elements were constraints, I don't believe they would be detected, as you've said. I'm not certain if this falls in the intended scope of the product, but I will raise the feature request and let you know the outcome. / comments
It greatly does, thank you.While we do have support for cross database dependencies, unless these elements were constraints, I don't believe they would be detected, as you've said.I'm not certain i...
Hello Guenter, If your experimentation, did you observe that the incorrect order was that elements of a single scripts were authored in the incorrect order? Or, were there individual scripts (I.E db objections) being executed in the wrong order please? This may seem like a semantic difference, they are handled by different parts of the code base. The simple answer to your question is no, there's no manual override, we'd need to identify and fix the issue. While what you've described is straight forward enough, in order to identify the issue we'd need to replicate the fault. I appreciate you likely cannot share you ETL process even privately, would you be able to create a small sample db that demonstrates the issue that we could use as a frame of reference? / comments
Hello Guenter,If your experimentation, did you observe that the incorrect order was that elements of a single scripts were authored in the incorrect order? Or, were there individual scripts (I.E db...
Hello gmazzitelli, Thank you for the question. yes it is. / comments
Hello gmazzitelli,Thank you for the question. yes it is.
I don't believe so. The path I'd expect this to take is that we intend to expose a programmatic interface for Flyway Desktop, which will allow for script authorship, including UNDO scripts. This functionality is already present in the tool, it's just the interface to allow you to invoke it that in the works. In the meantime, as you have SQL Compare available to you, could you use its cli to perform a diff between the supplied state and the current state? / comments
I don't believe so.The path I'd expect this to take is that we intend to expose a programmatic interface for Flyway Desktop, which will allow for script authorship, including UNDO scripts.This func...
Hello DavidWNAZ, Yes I'm afraid they are, there isn't interoperability between them. / comments
Hello DavidWNAZ,Yes I'm afraid they are, there isn't interoperability between them.
Yes, I should clarify. As you can see, you're able to progress now with an older version, that's what the cited post referred to, that this functionality was now unblocked. The statement "Oracle 12.2 is outside of Redgate community support. See https://rd.gt/468B6ni for details" means that issues might be unsupported for that db version. General flyway issues will of course continue to be worked on. Say for example there were historic bug in older flyway versions for this older db version, our allowing the functionality is 'as is' and not intending to broaden the support scope to avoid increasing development overhead. Were the issue also present in newer versions, it would be addressed. As for your missing schema history table, it reads to me as though it's failing silently due to lack of tablespace to write to. Is your admin user meant to be using the USERS tablespace and do they have a data allocation? Given your comment on attempting a manual insertion with another tool, it seems as though the user doesn't have the needed rights. / comments
Yes, I should clarify.As you can see, you're able to progress now with an older version, that's what the cited post referred to, that this functionality was now unblocked.The statement "Oracle 12.2...
Please can you verify if the tablespace property is appropriately populated? / comments
Please can you verify if the tablespace property is appropriately populated?
Apologies to keep you waiting MarkEHansen, I think the issue is the mismatch between Flyway and Spring versions. I believe it you update Spring to 3.1.6, the config issue should be resolved based off https://github.com/spring-projects/spring-boot/issues/38164 & https://github.com/spring-projects/spring-boot/issues/38267 / comments
Apologies to keep you waiting MarkEHansen, I think the issue is the mismatch between Flyway and Spring versions. I believe it you update Spring to 3.1.6, the config issue should be resolved based o...