Migrating Schema and Data along with code promotion

Can anyone give me pointers to software that will allow automating the migration of both schemas and data between different release levels with their own Oracle databases?

We have an integration environment, a testing environment, and a production environment, and a change in any of the tables, stored procedures, permissions, etc needs to be propagated as part of the code promotion process. There are also some tables that hold content, and the data in these likewise has to be promoted in lock-step with the code.

This seems like a common enough requirement, but the only solution I've found so far is the combination of Quest's Data Manager and Schema Manager. I looked at DBDiff, but it is very brittle, and DB Tools for Oracle looks like it is very low level for what I'm looking for. Perhaps I just haven't found the right combination of keywords to search on.

Another "nice-to-have" would be some sort of optional command-line interface or API, so that Ant support could be added (which will control the rest of the promotion process).

Has anyone got any suggestions about products (or open source) that I should look at?

Thanks for any suggestions. Received on Fri Sep 07 2001 - 00:51:30 CEST