Axel Fontaine - Database migrations with Flyway

[arun-gupta]

No description provided.

[arun-gupta]

• How do developers do db migrations without flyway
• Getting started samples
• How does it interact with JPA
• Comparison with Liquibase
• IDE support

[javornikolov]

• With changes of a db object scattered in multiple migration files: it might get hard to collect the bigger picture (the whole current state of the object and of the schema as a whole). How do we keep clarity on the big picture?
• Reverting database schema changes
• At install time is selected which modules to install. Later may install the skipped ones. (Module=subset of migrations). So depending on the environment - order of applying migrations (in same schema) might be different. Any hints for such scenarios?

[devopsd]

How do you add index on big table on DB running in production without blocking deployment pipeline?

[devopsd]

Does Flyway support migration rollbacks?

[cesarhernandezgt]

Common case scenarios of Flyway for testing environment.

[arun-gupta]

Hanginar link: https://plus.google.com/events/cq4df8h3pvvfipt1htppldj8qj0

Feb 18, Wednesday, 9:30am PT.

[giates]

Hi,

this is not an issue but a suggestion based on my experience...

I'm using Flyway on some of JEE7 projects and under Glassfish 4.1 I've found a little gotcha, see http://stackoverflow.com/questions/27881538/flyway-wrongly-load-and-execute-migration-definitions-of-each-ejb-module-of-de

In few words, if you've more than one ejb module with flyway migrations avoid to put the SQL migrations under db.migraion folder, instead use a folder with unique name for each different ejb module, then set the folder location during flyway process inizialization...

Hope this helps...