Cross-database changelogs

General Discussion
1

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