Hi.

We are working with Hibernate and have come to a point where we need to plan for production and future releases. In our development environment we auto-generate the tables but this won't be done in production environment (as recommended). Generating DDL's from hibernate is no problem, but what struck us was that it will be difficult to maintain in the future.

For example, after the first release the developers will start to develop next release. Add columns, drop columns etc until the next release is finished. Then, sure, it is easy enough to generate e new DDL. But we don't really need a new DDL, we need the delta between last DDL and the DDL, as a series of ALTER statements, or something similar. What we have found is:

Hbm2ddl.update:


So, this is close not really what we want. We don't want to run it against a database (in development environment, the database has already been auto updated), but a previous DDL. Is there any tools that can handle this?

Regards,
Magnus