Schema Compare for Oracle 3.0.6.714

richardjm

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)