How can we help you today? How can we help you today?

Flyway Snapshot

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?
DavidWNAZ
0

Comments

4 comments

Sort by
  • Peter_Laws
    Hello DavidWNAZ,

    Yes I'm afraid they are, there isn't interoperability between them.
    Peter_Laws
    0
  • 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
    0
  • 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?
    Peter_Laws
    0
  • DavidWNAZ
    Thanks...that is exactly what we're doing for now.  Thank you for all your input.  Have a great evening!
    DavidWNAZ
    0

Add comment

Please sign in to leave a comment.