Version 3.0.16 - July 10th, 2017

Fixes

• Fixed null reference exception on recreating object grants from older versions
• Fixed error on multiline text comparison

Version 3.0.15 - July 6th, 2017

12c

• Added support for roles granted to programs

Features

• Upgrade to SVN 1.9
• 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.0.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

Known issues

• At first run after upgrade you may have to check-in changes to GRANTs even if there are no visible changes in the SQL commands. This have to be done only once.

Version 3.0.12 - June 7th, 2017

Features

• OSC-682: Git repository on TFS server support

12c

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

Fixes

• OSC-715: Fixed saving default options after update SourceControl.
• OC-901, OC-833: Fix redundant GRANTS.

Version 3.0.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.0.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.0.9 - May 9th, 2017

Fixes

• Fixed error on parsing scripts folder for previous version 

Version 3.0.8 - May 8th, 2017

Features

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

Fixes

• OSC-700: Fixed difference highlighting independently case sensitive (in single quoted values)
• OSC-701: Fixed parsing disabled triggers

Version 3.0.7 - April 19th, 2017

Features

• TFS2015 client and server support.
• 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.0.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

12c

• Materialized view log: PURGE clause

Fixes

• Refactored use of SQL Source Control to remove redundant code
• Sanitized the installer
• OSC-644: Fixed changing branches, added information about refreshing. Fix to prevent empty dropdown list.
• OC-692: Fixed hidden scrollbars.
• 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.0.5 - January 4th, 2016

Features

• When working with multiple schemas on the same database with the same credentials, connections are shared for polling operations

Fixes

• The authentication prompt for Git now always allows the access token to be entered for all URLs
• Extra help information is now provided when linking to Microsoft Visual Studio Team Services to create access tokens for Git

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.0.4 - November 26th, 2015

Features

• Much faster start-up times when working with many projects
• "Refresh all" button added to front page to refresh all projects
• Quick access to settings within the project view via a settings button at the top of the page
• Upgrade to SVN 1.8

Fixes

• Locked objects with multiple words (eg "Package Body") now correctly show up on "Check in" and "Get latest" tabs

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.0.3 - September 23rd, 2015

Features

• "Include storage" options are now available in the project options
  

Fixes

• OSC-573, OSC-581: make sure TFS 2013 connection issues (with build agents) don't reoccur
• Previously, when you made changes to comparison options and other objects, you could only commit the updated comparison options and not the other changes. You now commit changes to comparison options before committing changes to other objects.

Schema Compare engine changes (used by Source Control for Oracle)

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.0.2 - August 11th, 2015

Schema Compare engine changes (used by Source Control for Oracle)

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.0.1.393 - June 29th, 2015

Fixes

• Cleanup of interactive help and general layout improvements
• Split panels in UI now have minimum sizes
• Updated icons and splash screen
• OSC-269: "'validationTooltip' name cannot be found..." issue believed fixed
• OSC-520: "Get latest" tab no longer incorrectly reports "You are up to date" when accepting changes from source control
• OSC-533: No longer throws an exception when a name conflict exists with a subobject when populating the "Lock objects" tab
• OSC-552: Connecting to a local Git repository using a uri (eg file:///c:/path/to/git) confirms that the repo exists and is bare

Schema Compare engine changes (used by Source Control for Oracle)

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.0.0.176 - April 21st, 2015

Features

• Git support (although merging branches within the tool is not yet supported)
• Working folder support - allows any source control system to be used with Source Control for Oracle

• Advanced search on Commit, Get latest, and Lock objects tabs (eg name:department lockedby:fred)

• “Select referenced objects” now considerably quicker for large schemas

Fixes

• OSC-288, OSC-393: Commit/Get latest tabs update properly after an attempt to automatically unlock locked objects when locking isn’t enabled on the database
• OSC-494: Error and warning messages no longer display on top of each other on Commit and Get latest tabs

• Commit message no longer incorrectly shows "Success!" when exceptions are generated during commit

Schema Compare engine changes (used by Source Control for Oracle)

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 isues - 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-736: OVERFLOW clause added to index-organized tables if needed even when “Ignore storage options” is enabled
• 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)