I'm attempting to give a rollback mechanism for my software that's associated with the database. I've two oracle db11g schemas which are different in structure and data. what are the tools that compare the upgraded schema using the old schema and produce a script that comes back the upgraded schema towards the original schema ?
If that's the case, will it range from the data itself ? or simply the db structure ?