What are the challenges you face when working across database platforms? Take the survey
Options

flyway_schema_history table

MadhuRapolluMadhuRapollu Posts: 1 New member
in Flyway (General Discussion)
I feel the Flyway metadata table, flyway_schema_history table, is pretty invasive. The source of truth for a schema definition can be the script itself (the latest version if there are multiple versions) and all that a user expects from Flyway is that to query the details of a schema and reconcile with the script, make the changes as needed.
Tagged:
· Share on Twitter

Answers

  • Options
    David AtkinsonDavid Atkinson Posts: 1,450 Rose Gold 2
    I think you're referring to the state-based approach where the deployment is based on comparing the source state with the target state. If so, Flyway supports this approach. When you create a project in Flyway Desktop make sure you set the deployment source as "schema model", which means deployments are calculated at deployment time, and no flyway_schema_history is required.

    (If you're not referring to the state-based approach, I'd be interested in hearing more!)
    David Atkinson
    Product Manager
    Redgate Software
    · Share on Twitter

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D;):\:/:o:s:p:'-(:|:-|B)o:)<38-)=)>_<:3:{/\:(`,`:‑J*|*<|>=}:[]:$B^D8D:‑D:O:'(>:O;‑]%‑);^)=p(~)=]xx:]
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • Flyway (General Discussion)Comment As ...