Flyway Snapshot

DavidWNAZ

We're using the Flyway snapshot command to create a snapshot of the target database prior to a migration.  But when attempting to open the file in SQL Compare, it errors in opening it.  Are they in different formats?

Peter_Laws

Hello DavidWNAZ,

Yes I'm afraid they are, there isn't interoperability between them.

Peter_Laws

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?

DavidWNAZ

Thank you, Peter.  Is there a roadmap to make that happen?  I'm trying to automate creating an UNDO script from a developer-provided SQL script in an Azure Devops pipeline.

DavidWNAZ

Thanks...that is exactly what we're doing for now.  Thank you for all your input.  Have a great evening!