Schema Compare for Oracle

Schema Compare for Oracle 3.1 release notes

Version 3.1.16 - July 10th, 2017

Fixes

  • Fixed null reference exception on recreating object grants from older versions

Version 3.1.15 - July 6th, 2017

12c

  • Added support for roles granted to programs

Features

  • OC-767: Missing view feature (WITH OBJECT_IDENTIFIER)
  • Added support for roles granted to schema

Fixes

  • OSC-717/OC-731: For SYNONYMS the ExcludeTargetSchemaName option should not apply to the FOR statement.
  • OC-819: Fixed marking difference when white characters occur in multi-line character values (single quote).
  • Fixed duplicate key error after multi-schema comparision with objects sharing same name in different schemas.
  • Fixed object grants duplication in deploy script when deploying from snapshot to database.

Version 3.1.14 - June 21st, 2017

12c

  • Table: Clustering attribute support: added clustering_join clause.

Fixes

  • OC-899/OC-900: Fixed parsing Constraint for JSON with (LAX)
  • OSC-707: Fixed error "The key already existed in the dictionary." after check-in and refreshing the object
  • OC-903/OC-901/OC-833: Fixed problems with "Out of Memory Exception." during comparison on 32bit application and poor performance

Version 3.1.12 - June 7th, 2017

12c

  • Table: Clustering attribute support: cluster_clasue (clustering_columns, clustering_column_group), clustering_when clause

Fixes

  • OC-831: Deployment script lines > 2499 formatting (Helpful for SQL Plus users)
  • OC-896: Fix for command line (when using project file)
  • OC-901, OC-833: Fix redundant GRANTS

Version 3.1.11 - May 22nd, 2017

12c

  • Tables: Period For clause support
  • Tables: Advanced index compression support

Fixes

  • Fix issue when non-DBA user has permission to DBA_USERS
  • Storage Options - common code base for Tables, Materialized Views and Indexes

Version 3.1.10 - May 15th, 2017

Fixes

  • OSC-707, OC-893: Fix differentiation between dba and non-dba user for GRANTS
  • OC-895: Fix problem with multi-threading and access to script files

Version 3.1.9 - May 9th, 2017

Fixes

  • Fixed error on parsing scripts folder for previous version

Version 3.1.8 - May 8th, 2017

Features

  • Add support for system privileges
  • Add support for object privileges
  • OSC-645: Added storage support for materialized view

Fixes

  • OC-888: Fixed marking difference when whitespace occurs in chars values (single quoted)
  • OSC-701: Fixed parsing disabled triggers

Version 3.1.7 - April 19th, 2017

Features

  • Materialized Views: Deferred Segment Creation clause

12c

  • Materialized Views: Compress clause
  • Materialized Views: Inmemory clause
  • Materialized Views: Heap clause

Fixes

  • OC-883: Fixed creating constraint with index in Materialized View.

Version 3.1.6 - April 3rd, 2017

Features

12c

  • Materialized view log: PURGE clause

Fixes

  • Fixed image directory separator. Accessing interactive comparison report from a web server will load images while using Firefox.
  • OC-879: Fixed generate of objects qualified names during scripting.
  • Script for altering MATERIALIZED VIEW LOG now places FORCE keyword in proper place
  • OC-564: Fixed supporting INTERVAL clause for range table partitioning.
  • OC-804: Fixed conversion from DbNull to string exception occurring in the population of foreign keys.
  • OC-827: Dependency population speed increased
  • OC-839: Fixed reading table objects with LOB's and partitions referenced from other tables
  • OSC-685: Fixed creating index on JSON type field in table.
  • OSC-686: Fixed creating triggers if there is no trigger body and description in DBA_SOURCES.

Version 3.1.5 - January 4th, 2016

Fixes

  • OC-588: Cluster storage is now stored correctly in snapshot files

Schema Compare engine updates

Fixes

  • OC-616: GRANT statements to other schemas now script after object creation
  • OC-725: GRANT REFERENCES now come before referencing object when comparing multiple schemas
  • OC-802: Index type population no longer fails due to unpopulated operators
  • OSC-588: String literals escaped with q' or table definitions containing q' no longer fail to parse
  • Using the non-default option "dependent options in other schemas" no longer hangs during population

12c

  • Table: Support in memory options on partitions
  • Table: Support new compression options
  • Index: Support for Unusable option on partitions and subpartitions

Version 3.1.4 - November 26th, 2015

Fixes

  • The command line no longer shows issues or warnings that are not relevant when deploying to a scripts folder

Schema compare engine updates

Features

  • Performance improvement as live database population now works on many threads, previously just two
  • Quoted string literals in default values are now parsed and strings are considered equal regardless of quoting method

12c

  • Tables: Indexing clause
  • Indexes: Partial index clause
  • Table: ILM clause
  • Table: INMEMORY support
  • Package: EDITIONABLE/NONEDITIONABLE keyword
  • Type: EDITIONABLE/NONEDITIONABLE keyword
  • Function: EDITIONABLE/NONEDITIONABLE keyword
  • Procedure: EDITIONABLE/NONEDITIONABLE keyword
  • JSON: support for IS JSON, JSONEXISTS(), JSONTEXTCONTAINS() conditions

Fixes

  • %TYPE attribute used in types no longer causes parsing failures
  • Correctly synchronizes primary key and unique indexes that have identical columns but in different orders
  • New lines in column names no longer causes parsing failures
  • Disabled unique constraints on views now supported
  • OC-796 - Deployment script is no longer empty when comparing domain indexes that differ by parameter contents

Version 3.1.3 - September 23rd, 2015

Features

  • New "Include storage" options are now available for projects

Command line

  • /storage:<value> added to "Include storage" options
  • /resolve:<issue>:<resolution> added to resolve script generation issues
  • Issues generated during script creation are output on the command line
  • OC-787: errors on command line show actual error text rather than "One or more errors occurred."

Schema Compare engine updates

12c

  • Trigger: EDITIONABLE/NONEDITIONABLE keyword
  • Table: ROW ARCHIVAL clause
  • Table: DEFAULT ON NULL clause
  • Table: EVALUATE USING clause
  • Table: UNUSABLE EDITIONS clause

Features

  • Table: ENCRYPT clause
  • New option: Include compression
  • New option: Include extents
  • New option: Include INITRANS
  • New option: Include lobs
  • New option: Include logging
  • New option: Include PCTFREE
  • New option: Include tablespaces and partitioning
  • Support modifying types referenced by another type
  • Improve population speed by reducing unused population

Fixes

  • Comments between WITH CHECK OPTION and ; in view definition no longer affect constraint population when reading from script files
  • Differences in newline format are no longer identified as differences (eg /n is equivalent to /r/n)
  • Comments within CHECK constraints are included when reading from script files
  • Multi-column constraints no longer fail to parse when reading from script files
  • OC-783: Column rename detection option can now be completely turned off
  • Upgraded third party library to get the latest bug fixes, including:
    • Negative numbers no longer become positive when being read in x64 mode under .NET 4.6

Version 3.1.2 - August 11th, 2015

Features

Command line

  • Support for new "Ignore length semantics" option

  • Passwords are no longer displayed in the verbose output

Fixes

  • Options are now stored in full, allowing new options to be introduced in the future
  • "My Defaults" will be reset for any new projects
  • "Ignore storage" is now "Include: all storage options", making way for granular storage options

Schema Compare engine updates

Features

  • View: EDITIONING keyword
  • New: "Ignore length semantics" option to ignore BYTE/CHAR differences when comparing CHAR and VARCHAR2 columns
  • 12c:
    • Materialized view: UNUSABLE EDITIONS clause
    • Materialized view: EVALUATE USING clause
    • Materialized view log: FOR REFRESH clause
    • Materialized view log: COMMIT SCN option
    • View: EDITIONABLE/NONEDITIONABLE keyword
    • View: Constraint name supported in read-only subquery restriction

Fixes

  • OC-749: Comparing multiple schemas to a scripts folder with "Exclude schema names" option turned on no longer throws an exception
  • OSC-550: Batch separator now included when scripting type and type body
  • OSC-556: Improved parsing of subquery restriction clause in views
  • OSC-558: Fixed parsing of views without column definitions
  • Storage clause improvements and fixes preparing for upcoming granular storage options

Version 3.1.1.350 - June 29th, 2015

Features

Command line

  • /loglevel:error|warning|verbose to create full Redgate log files
  • /verbose and /quiet to control ouput

Fixes

  • OC-218: "Save changes before closing project" dialog box now appears each time you try to exit without saving
  • OC-762: Setting "My defaults" in the project options overrides the options set in "Red Gate Defaults"
  • Updated icons and splash screen

Schema Compare engine updates

Features

  • Added new "Suppress alter compile" option to turn off all calculations and scripting associated with performing an ALTER COMPILE on objects which are dependent on those which are deployed
  • 12c:
    • Table: IDENTITY columns
    • Table: INVISIBLE/VISIBLE columns
    • Synonym: EDITIONABLE/NONEDITIONABLE keyword
    • View: BEQUEATH keyword
    • View: INVISIBLE/VISIBLE columns

Fixes

  • Automatic column rename detection is now enabled for materialized views
  • Oracle connections are now closed when reading schema and database information
  • OSC-515: Spatial indexes and object property indexes are now scripted correctly
  • OSC-539: Synonyms and sequences are now scripted with trailing ; in .sql files
  • OSC-544: Materialized views no longer compare old refresh information if NEVER REFRESH is selected
  • OC-752: External tables are now stored correctly in snapshot files
  • OC-756: ENABLE ROW MOVEMENT is no longer registered as a difference when "Ignore storage" option is turned off
  • OC-765: The DISABLE keyword in foreign key is now in the correct location (after DEFERRABLE)
  • OC-768: Column rename detection is now disabled for external tables

Version 3.1.0.137 - April 21st, 2015

Features

  • 12c support for KEEP/SESSION on sequences

  • 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

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-735: Grants are now scripted with sequence during creation
  • OC-736: OVERFLOW clause added to index-organized tables if needed even when “Ignore storage options” is enabled

  • OC-745: Report generation is now filtered when using /Filter:<file> option on command line
  • OC-747: Always create scripts in the format of the source when deploying to an empty scripts folder (previously 12c scripts would initially be created as 11g scripts)
  • OC-752: EXTERNAL table storage now serialized in snapshot files

  • "Show PL/SQL difference" now works with materialized views

 Releases


Didn't find what you were looking for?