As a Java Developper using JPA/Hibernate, I am looking for a will help diff a database that has been generated by Hibernate with a production database.
I've already looked at LiquiBase's abilities LiquiBase which is quite nice... Unfortunlately it is plagued by some weird bugs:
- Re-Create Foreign Keys for no reason
- Re-Create Indexes for no reason
I'm not entirely sure that it's Liquibase's fault as much as the JDBC Driver Implementation that are not consistent with the specification. I would be probably be plagued by the same issues if I even tried to roll out my own.
I am looking for a non Java-based solution that would support:
- MySQL
- PostgreSQL
- Oracle
- DB2