We are currently looking for a database migration and sql generator to introduce into our projects and we've searching with no success for a tool that is able to accomplish all the following:
- Support for Oracle, PostgreSQL and H2 databases.
- Migration capabilities that allow to keep track on which version the databases are.
- From two SQL dumps or connections, calculate the differences between the databases or schemas, then returns migration from A to B and regression from B to A. Ideally the tool would also be capable of dumping the databases.
Any recommendation would be greatly appreciated as we really are in need for help.
Thank you very much.