javaee-samples
Axel Fontaine - Database migrations with Flyway
- How do developers do db migrations without flyway
- Getting started samples
- How does it interact with JPA
- Comparison with Liquibase
- IDE support
- 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?
How do you add index on big table on DB running in production without blocking deployment pipeline?
Hanginar link: https://plus.google.com/events/cq4df8h3pvvfipt1htppldj8qj0
Feb 18, Wednesday, 9:30am PT.
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...
