> While it might be OK for development or to consolidate existing
> databases to a common denominator once, relying on a metadata compare
> tool in the field, which produces some kind of incremental script, that
> gets executed automatically against a production database, is IMHO a can
> of worm. I simply wouldn't trust such a solution.

I agree as well.

We are pretty happy using Liquibase for this. It also handles the tracking which changes have been applied and can also run different code depending on the underlying DBMS (if needed).

Another option is Flyway which uses a less restrictive approach, but basically does the same.