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

• New login based licensing: see https://www.red-gate.com/user-licensing for more details
• Streamlined new update checking interface
• UI/CLI changes to expose ways how to connect using Oracle wallet

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