Options
Schema Compare for Oracle 3.1.0.137
richardjm
Posts: 598
A minor release fixing a few issues and adding a few new features. "Check for updates" off the help menu to update within the tool.
Schema Compare for Oracle
Fixes
OC-735: Grants are now scripted with sequence during creation
OC-745: Report generation now filtered when using /Filter:<file> option on command line
OC-752: EXTERNAL table storage now serialized in snapshot files
“Show PL/SQL difference†now works with materialized views
Schema Compare Engine
Features
OC-732: Schema population now falls back to using all_tables at all points in population if access to dba_is disallowed
OC-738: New option to generate "DROP TABLE ... PURGE" in deployment scripts
OC-740: Allow implicit conversion of DATE to TIMESTAMP types
12c support for KEEP/SESSION on sequences
Fixes
OSC-398: Nested table clause moved before CACHE/PARALLEL in script generation to fix parsing issues - generated SQL files will have to be removed from source control
OC-708: Now correctly parses SET DEFINE OFF or SET SQLBLANKLINES ON in *.sql files
OC-715: MDXT_...$ tables now excluded from comparison (statistics tables generated by Oracle for spatial indexes)
OC-738: OVERFLOW clause added to index-organized tables if needed even when “Ignore storage options†is enabled
OC-747: Scripts are now always created in the format of the source when deploying to an empty scripts folder (previously 12c scripts would initially be created as 11g scripts)
Schema Compare for Oracle
Fixes
OC-735: Grants are now scripted with sequence during creation
OC-745: Report generation now filtered when using /Filter:<file> option on command line
OC-752: EXTERNAL table storage now serialized in snapshot files
“Show PL/SQL difference†now works with materialized views
Schema Compare Engine
Features
OC-732: Schema population now falls back to using all_tables at all points in population if access to dba_is disallowed
OC-738: New option to generate "DROP TABLE ... PURGE" in deployment scripts
OC-740: Allow implicit conversion of DATE to TIMESTAMP types
12c support for KEEP/SESSION on sequences
Fixes
OSC-398: Nested table clause moved before CACHE/PARALLEL in script generation to fix parsing issues - generated SQL files will have to be removed from source control
OC-708: Now correctly parses SET DEFINE OFF or SET SQLBLANKLINES ON in *.sql files
OC-715: MDXT_...$ tables now excluded from comparison (statistics tables generated by Oracle for spatial indexes)
OC-738: OVERFLOW clause added to index-organized tables if needed even when “Ignore storage options†is enabled
OC-747: Scripts are now always created in the format of the source when deploying to an empty scripts folder (previously 12c scripts would initially be created as 11g scripts)
