Hi there,
I’m starting a new Maven, Spring, Hibernate, CXF backend JAVA project and I’m currently studying the db migration problem.
First I went for flyway for its simplicity but I lately realized that SQL-based migration scripts aren’t cross-database at all.
Then I found Liquibase XML-based migration scripts but the manual defines DB-dependant examples :
http://www.liquibase.org/samples/changelogs/mysql.changelog.xml
http://www.liquibase.org/samples/changelogs/oracle.changelog.xml
So I’m wondering : is there a way to define a fully cross-database Liquibase XML-based changelog ?
It seems to me that it is achievable since you don’t use auto-increment primary key, am I right ?
If so, is it possible that Hibernate handle auto-increment itself ? Won’t it be a major performance pitfall ?
Thanks for your answsers,
Regards,
Pierre GAUTIER