Hi everybody
Oracle DB 11g
Is there any tools helping to compare two schemas and get diff report and update script for synchronizing these schemas?
I mean something like embedded into 'pl/sql developer'/'sql developer'/'dbForge Schema Compare for Oracle' tools but what i can run from command line with parameters.
I want to see diff between all of the objects in DB(tables (incl comments), views, synonyms, seqs, programms, privs(?) and so on)
It would be great if i could see diff in data and get dml script
Ive found Jeff Hunter-s script
http://www.idevelopment.info/data/Oracle/DBA_scripts/Database_Administration/dba_compare_schemas.sql
but the comments are excluded and there is no update script (only diff report)
There is DBMS_METADATA_DIFF.COMPARE_ALTER function, but not all of the types of objects are supported
There is DBMS_COMPARISON package but it doesnt create update script and synchronizes objects within the db and i have to specify object name(noth the whole schema name) and all the table have to be indexed
May be there are any freeware tools?