Page 1 of 1

Database Migration

Posted: Mon Oct 28, 2013 5:15 pm
by maurosergiosilva
Suport to some database migration api (like flywaydb http://flywaydb.org)
So when you install a module, update an module or an broadleaf version it manage the database migration stuff.

Re: Database Migration

Posted: Mon Oct 28, 2013 9:41 pm
by phillipuniverse
Flyway is cool, we have been recently experimenting more with Liquibase (http://www.liquibase.org/). It works really well and that's probably what we will end up recommending unless there is a compelling feature from Flyway.

Currently, there are some ant tasks in the DemoSite code (build-create-sql and build-update-sql) that will assist in migrations (build-update-sql is the one built for that). We'll end up deprecating this in lieu of Liquibase.

Have you used Flyway? Any particular reason you know of that would be better than Liquibase?

Re: Database Migration

Posted: Wed Oct 30, 2013 6:25 am
by maurosergiosilva
Hi Philipe,
I dont know liquidbase. I sugest flyway couse I use it in live projects.
Its very simple, suport SQL so I culd use DBA Team to deal with SQL stuffs and Java Team with Java Stuffs.
There is a comparation on stackoverflow http://stackoverflow.com/questions/8418 ... -or-flyway
Other question Liquidbase Support multiple schema? If you see on flayway feature comparation it seams the liquidbase dont support it.