4:08 p.m.
[
https://issues.jboss.org/browse/FORGEPLUGINS-54?page=com.atlassian.jira.p...
]
George Gastaldi edited comment on FORGEPLUGINS-54 at 3/23/15 5:07 PM:
----------------------------------------------------------------------
Potential tools/libraries that already work through database upgrades:
Liquibase - http://www.liquibase.org/, strongest, mature available tool (based on my
research). JPA or integration effort unknown. Used in Grails database migration plugin.
Flyway - http://flywaydb.org/, comparatively new, but gaining lot of traction. Used in
Spring Roo as add-on (http://code.google.com/p/spring-roo-addon-flyway/)
There are others, however these two seem to be the strongest candidate given they already
have been used in similar plugin approaches. Personally I have had good experience with
liquibase as a standalone database change tool, but never used it tightly coupled with a
programming language for domain<->db change management.
flyway to liquibase comparison:
http://stackoverflow.com/questions/8418814/db-migration-tool-liquibase-or...
was (Author: dhartford):
Potential tools/libraries that already work through database upgrades:
Liquibase - http://www.liquibase.org/, strongest, mature available tool (based on my
research). JPA or integration effort unknown. Used in Grails database migration plugin.
Flyway - http://code.google.com/p/flyway/, comparatively new, but gaining lot of traction.
Used in Spring Roo as add-on (http://code.google.com/p/spring-roo-addon-flyway/)
There are others, however these two seem to be the strongest candidate given they already
have been used in similar plugin approaches. Personally I have had good experience with
liquibase as a standalone database change tool, but never used it tightly coupled with a
programming language for domain<->db change management.
flyway to liquibase comparison:
http://stackoverflow.com/questions/8418814/db-migration-tool-liquibase-or...
Plugin to Database Migration Framework
--------------------------------------
Key: FORGEPLUGINS-54
URL: https://issues.jboss.org/browse/FORGEPLUGINS-54
Project: Forge Plugins/Addons
Issue Type: Feature Request
Reporter: Mauro Silva
Recommend idea for adding a database change plugin. The Grails plugin for database
changes (http://grails.org/plugin/database-migration) may be good for inspiration, however
the Forge version may not necessarily have the tightly coupled support as the
Grails/Groovy domain models have, but something that supports JPA would be fabulous.
Although a generic plugin for Liquibase or other database change management support could
be useful, it would be left 'up to the developer' on how to use it which seems
counter-intuitive to a more RAD-style development environment, per the specific of
JPA-based data access (potentially OGM-based JPA as well).
Usecase is for solving how to deploy database structure changes in an automated fashion
to ensure the database schema does not go out of sync with the application.
A Plugin like spring-roo-addon-flyway
(http://code.google.com/p/spring-roo-addon-flyway/).
Could be other Database Migration API that works better on Jboss ecosystem (I dont know
if that is one).
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)