Schema Compare for Oracle

richardjmrichardjm Posts: 598
edited December 4, 2014 7:27AM in Schema Compare for Oracle
A large update of Schema Compare is now available via your friendly "Check for updates" (on the help menu) or to download directly from our website.

Schema Compare for Oracle
  • Script summary display could fail (OC-511)
  • Default warnings list by severity
  • Report generation would fail with certain characters in comments
  • Don't require .NET35 for install - only .NET4+ Full needed
  • Command line:
    • /exclude:Additional|Different|Missing to prevent deployment of all objects if required
    • /filter:Filter.scpf - automatic if file present (e.g. from a SOCO checkout)
    • /deployallobjects valid when targeting only script file
    • warning ouput format changed
    • /abortonwarnings will abort script creation (OC-711)

Schema Compare Engine
  • Public Synonym support (on by default)
  • "Ignore storage" option support much improved
  • Failure to populate PL/SQL object text would not fail population, instead cause subsequent null value errors
  • Compression clause for different Oracle versions script correctly
  • Allow ; on end of synonym statement in file
  • Never attempt to drop SYS schema objects
  • Don't attempt to RECOMPILE nested tables or varrays
  • Column rename detection in combination with indexes scripted incorrectly
  • Column rename detection could incorrectly prioritize fuzzy matching over exact column names
  • Column rename detection in combination with a table rebuild was very broken
  • Materialized views no longer script hidden fields (OSC-415)
  • Materialized views on indexes depend on materialized view (OSC-415)
  • Materialized view logs depend on the materialized view (OSC-415)
  • Materialized views support CACHE clause
  • NOVALIDATE clause moved to after DEFERRABLE clause for constraints (OC-713)
  • Ignore external table in combination with table rebuild would fail to generate sync script (OC-681,OC-693)
  • Keywords as part of columns names in check constraints were incorrectly escaped (OSC-337)
Richard Mitchell
Project Manager
Red Gate Software Ltd
Sign In or Register to comment.