dhite99
asked on
ORACLE: How to Compare Schemas from Different Databases
Hi,
I have a requirement to compare schemas (objects, column defs, etc,.etc, but not data) from two different databases. I know there are many products that facilitate this, including TOAD and OEM, but the catch is that I cannot compare the schemas 'live' - that is, I need to extract the schema definitions to file(s) and then use some kind of method to compare the files. I am not allowed to connect to both databases simultaneously.
Any ideas would be appreciated - thanks!
I have a requirement to compare schemas (objects, column defs, etc,.etc, but not data) from two different databases. I know there are many products that facilitate this, including TOAD and OEM, but the catch is that I cannot compare the schemas 'live' - that is, I need to extract the schema definitions to file(s) and then use some kind of method to compare the files. I am not allowed to connect to both databases simultaneously.
Any ideas would be appreciated - thanks!
Last Comment
You might be able to use dbms_metadata.get_ddl for each schema and if you are lucky just diff the files.
Instead of a backup/restore, create a 'compare' database and create two new schemas and rebuild the objects and compare those? If this is an option then I would use export/import (the old exp/imp or new expdp/impdp) with no rows.
Instead of a backup/restore, create a 'compare' database and create two new schemas and rebuild the objects and compare those? If this is an option then I would use export/import (the old exp/imp or new expdp/impdp) with no rows.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks
Extract DDL and compare was previously suggested twice.
Any reason the points weren't split if you liked the SQL Developer idea?
Any reason the points weren't split if you liked the SQL Developer idea?
Oracle Database
Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.
81K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
I guess file comparision might take lot of time if you are trying to compare offline.
Other option you can think of is to take a backup of these 2 DB's and restore it on temp server, do the comparision using TOAD, OEM, get the results and drop those DB's when your analysis is done
May be other experts can provide their comments as well