Axel Fontaine - Database migrations with Flyway

javaee-samples / webinars

Java EE Webinar Series

34 stars 11 forks source link

Axel Fontaine - Database migrations with Flyway #3

Open arun-gupta opened 9 years ago

arun-gupta commented 9 years ago

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

javornikolov commented 9 years ago

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 commented 9 years ago

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

devopsd commented 9 years ago

Does Flyway support migration rollbacks?

cesarhernandezgt commented 9 years ago

Common case scenarios of Flyway for testing environment.

arun-gupta commented 9 years ago

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

Feb 18, Wednesday, 9:30am PT.

giates commented 9 years ago

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...