Any tools to rollback schema change and map new data to old schema?
471462Sep 20 2006 — edited Sep 21 2006What is the best way to rollback a schema change, but preserve the data that is in the new schema?
We are updating an application for a customer, however the customer would like to rollback to the old application if after a few days they run into a critical problem.
The application schema is changing - not a lot, but a number of tables will have extra columns.
To rollback, one would have to re-create the original schema and load data into it from the updated schema.
I thought that the Migration toolkit/workbench might have been able to do this for Oracle --> Oracle migrations, but it appears to only support non-Oracle Database migrations to Oracle.
Are there any oracle tools in say OEM or elsewhere that can handle data transformations?