Hello all
I have been asked to compare schema definitions across 2 DBs, one of which is a PRODUCTION DB.
My plan is to generate a METADATA_ONLY EXPORT of each of the schemas on the PRODUCTION and the SANDBOX DBs (the other DB).
I will create a SCRATCH DB and import using SQLFILE to generate the metadata outputs by alternately importing the same schema from both the dumps.
I will compare the outputs.
QUESTION 1 : Will the METADATA_ONLY export dump file be small since it will have no data ? I will be trying this of course, but I want to be careful before doing this on PROD.
QUESTION 2 : Is this an accurate method - as accurate as using paid-for software. No I do not even want to use SQL Developer's Database Diff.
QUESTION 3 : Will database jobs belonging to a schema be exported ?
QUESTION 4 : Is a METADATA export faster since there is no data ?
FINALLY : Anything I should be worried about ?
Many thanks