I am currently using Apache DdlUtils to generate SQL for different databases using XML. Is there a tool that can automatically generate patch SQL for different versions?
For example, from version 1.0 to 2.0:
- Some tables added new columns.
- Some tables modified column types.
- Added new insert statements.
I think my current Apache DdlUtils should not be able to do this.
I expect to output ALTER TABLE COLUMN SQL statements and new insert statements for this time. I expect that I can specify the database definition contents of two versions and produce patch SQL based on the differences.
