Source Control for Oracle 4

Source Control for Oracle 2.0 release notes

Version 2.0.10.1242 - February 19th, 2015

This is the last Source Control for Oracle 2. The next release will be Source Control for Oracle 3. You can get it free if your support and upgrades are up to date.

Features

  • Improved performance when dealing with lots of objects

Fixes

  • OSC-450: Number of objects selected is now displayed correctly
  • OSC-461: Passwords with special characters are now escaped correctly
  • ODC-303, OSC-468, OC-725: Instant client 12.1.0.2.0 no longer returns "Input string was not in a correct format" with DBMS_UTILITY.DB_VERSION

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

Fixes

  • OC-615: Fixed grants sometimes being created before objects
  • OC-699: Possibly fixed "ObjectDisposedException" error during population
  • OC-735: Grants are now scripted with new sequences
  • OC-736: Index-organized tables with overflow segments now include basic OVERFLOW in script even when storage options are turned off

Version 2.0.7.1037 - December 18, 2014

Features

  •  Project listings now include SID/Service name and port information for manual connections
  •  Project listings now include counts for both get latest and check in

Fixes

  •  OSC-436: Saving schema comparison options now works with TFS
  •  Projects using schemas with folders of different names now register correct differences
  •  Several bugs with conflict resolution fixed

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

  • OC-716: Deploying primary keys and foreign keys together are now ordered correctly in the script

Version 2.0.6.964 - December 4, 2014

To downgrade to an older version of Source Control for Oracle after installing this version, you first need to delete the %localappdata%\Red Gate\Source Control for Oracle 2 folder.

Features

  • Refresh projects twice as quickly
  • TFS2013 client and server support
  • Updated source control engine
  • Schema Compare for Oracle options now available in Source Control (except "Ignore storage")
  • Evaluation repository for easy evaluation
  • See the refresh progress on the Check in and Get latest tabs

Fixes

  • Sort order now remembered when refreshing commit and get latest tabs

Schema Compare engine

This version also contains updates to the Schema Compare engine, which Source Control for Oracle uses:

Features

  • Public synonyms now supported (can be excluded with filters)
  • "Ignore storage" option support much improved, especially comparing to scripts

Fixes

  • OSC-337: Keywords as part of columns names in check constraints now correctly escaped
  • OSC-415: Materialized views no longer script hidden fields
  • OSC-415: Materialized views on indexes now depend on materialized view
  • OSC-415: Materialized view logs now depend on the materialized view
  • OC-681 and OC-693: Using the Ignore external table location option in combination with a table rebuild no longer fails to generate sync script
  • OC-713: NOVALIDATE clause moved after DEFERRABLE clause for constraints
  • Failure to populate PL/SQL object text now fails population instead of causing subsequent null value errors
  • Compression clause for different Oracle versions now scripts correctly
  • Semicolons on the ends of synonym statements in script files are now allowed
  • No longer attempts to drop SYS schema objects
  • No longer attempts to RECOMPILE nested tables or varrays
  • Column rename detection in combination with indexes now scripted correctly
  • Column rename detection no longer incorrectly prioritizes fuzzy matching over exact column names
  • Column rename detection in combination with a table rebuild fixed
  • Materialized views now support CACHE clause

Version 2.0.5.742 - October 13, 2014

Features

Fixes

  • Refreshing when search box has text in it no longer causes crashes
  • Search box no longer momentarily disappears when refreshing the Lock objects tab

Schema Compare engine

This version also contains updates to the Schema Compare engine, which Source Control for Oracle uses:

Features

  • Use semicolons on CREATE SEQUENCE statement endings
  • More parsing of 12c object privileges (USE, FLASHBACK ARCHIVE, KEEP SEQUENCE, INHERIT PRIVILEGES, TRANSLATE SQL)
  • Ignore tables and sequences created for spatial indexes
  • Support for materialized view PARALLEL keyword

Fixes

  • Command line: /abortonwarnings switch now works properly
  • Materialized views ending with a single line comment (ie "--") no longer produce invalid SQL when scripted
  • Grant user object privilege with the "exclude schema names" option no longer causes crashes

  • Views no longer erroneously marked as different when “WITH READ ONLY” or “WITH CHECK OPTION” is in lowercase

Version 2.3.489 - August 6th, 2014

Features

  • Connect using LDAP lookup (beta). Enter the host name in the Network alias field using a TNS connection
  • Connect using OS authentication when connecting via TNS connection

Schema Compare engine

  • CREATE OR REPLACE used for all objects in scripts (not marked as a difference)

Bug fixes

  • Rendering on startup when restoring position
  • OSC-81: No longer crashes when running on .NET4.0 and viewing comparison on a modified line ending with white space

Schema Compare engine

  • Column rename detection supports ordinal and primary keys
  • Column rename detection exact match takes precedence
  • Views no longer marked as different when system-named index or constraints are deployed
  • OSC-358: Population no longer fails when encountering multiple references to a dependency
  • Parsing of views no longer dependent on white space following ") AS"
  • Parsing no longer fails when using EXTERNAL ORACLE_DATAPUMP without ACCESS PARAMETERS 
  • Population of default Oracle schema (eg HR) now complete if included in schemas to populate
  • Warnings now appear when trying to deploy clusters, because they're unsupported
  • Fixed SQL for indexes on existing clusters

Version 2.0.2.404 - July 16th, 2014

Features

  • Projects are now listed in alphabetical order
  • When typing in the filter box, filtering is delayed until typing stops
  • Tooltips are displayed on hover for project names
  • Partitions and lobs can no longer be locked in the Lock objects tab

Schema Compare engine updates

  • Rename column detection
  • Scripts folder population is approximately 25% faster
  • Improved nested table support
  • Materialized view definitions are no longer always in brackets
  • Materialized view comment support - default comment excluded
  • Skip GRDMLTR_* (auto-generated) triggers for SDO_GeoRaster columns
  • Copy NOVALIDATE for constraints if specified
  • Removal of some unused schema population
  • Improved logging of population speed
  • Joined indexes depend on all joined tables
  • Script parsing errors:
    • Interval literal support for materialized views e.g. "NEXT trunc(sysdate,'HH') + interval'1'"
    • Fixed view parsing to cope with "cast(trunc(systimestamp, 'DD') as timestamp)" 
    • Parsing of materialized view starting with newline would fail
    • Allow U'' style string literals
    • Tables with external data failed if column names ended in "location" 

Version 2.0.1.173 - May 22nd, 2014

Features 

  • Improved materialized view support (grants, complex queries, column aliases)
  • Out-of-line constraints in Table SQL now supported 
  • Service name connections supported if Oracle Instant Client is installed 

Version 2.0.0.129 - December 18th, 2013

Bug fix

  • Exception no longer occurs when refreshing after changing password

Version 2.0.0.125 - November 19th, 2013

Bug fix

  • SYS_NT tables are ignored

Version 2.0.0.121 - November 1st, 2013

 Features

  • Previous/Next difference buttons
  • Dialog to warn user that locked objects will be unlocked on check-in

Bug fixes

  • Increased time-out when connecting to Oracle
  • Matching Indexes to constraints where columns are not in same order
  • Parsing of materialized views with new lines before opening bracket
  • Parsing of triggers with inline comments

Version 2.0.0.104 - September 23rd, 2013

Feature

  • Support for nested tables

Bug fixes

  • RELY DISABLE in scripts folders now backwards compatible  

Version 2.0.0.101 - September 17th, 2013

Bug fixes

  • PL/SQL objects with quoted string literals always appearing as different
  • MVIEWS with subqueries

Version 2.0.0.99 - August 22nd, 2013

Bug fixes

  • White space-only comments causing tables to have invisible differences
  • Primary keys using a custom index with more columns than the constraint appearing different
  • Parsing of PARALLEL clauses with just the DEGREE included 
  • Parsing of RELY DISABLE
  • Allow control characters in table/view/column comments
  • Parsing of PL/SQL comments between the OBJECT TYPE and OBJECT NAME
  • Number of objects selected text can be wrong after check-in
  • Locked objects not appearing after being dropped
  • Materialized views reappearing as different after every refresh

Version 2.0.0.87 - August 12, 2013

New features


Didn't find what you were looking for?