Schema Compare for Oracle 4

Schema Compare for Oracle 3.0 release notes

Version - February 19th, 2015


  • Upgrade no longer required for older schema folder directories


  • ODC-303, OSC-468, OC-725: Instant client no longer returns "Input string was not in a correct format" with DBMS_UTILITY.DB_VERSION
  • OSC-461: Special characters in passwords now work in the command line
  • OSC-461: Passwords with special characters are now escaped correctly
  • 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 - - December 18th, 2014


  • UI alignment improved when editing data sources
  • Upgrading a scripts folder now overwrites the entire folder, including read-only files
  • OC-716: Deploying primary keys and foreign keys together are now ordered correctly in the script

Version - - December 4th, 2014


  • Public synonyms now supported (can be excluded with filters)
  • "Ignore storage" option support much improved, especially comparing to scripts
  • Default warnings are listed by severity
  • New command line commands:
    • /exclude:Additional|Different|Missing to prevent deployment of all objects if required
    • /filter:Filter.scpf to filter objects being deployed, automatic if file present (for example from a Source Control for Oracle Checkout)
    • /deployallobjects valid when targeting only script file


  • 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 - - October 14th, 2014


  • Snapshots including views with alias columns now load properly
  • Use semicolons on CREATE SEQUENCE statement endings
  • Ignore tables and sequences created for spatial indexes
  • Support for materialized view PARALLEL keyword


  • 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 - - August 6th, 2014


  • Connect using LDAP lookup (beta). On the TNS Connection tab, type the host name in the Network alias field
  • Connect using OS authentication when connecting via TNS
  • Ignore external table location when comparing ( /ignore=external-table-location)
  • Deserializing speed improved by reducing logging, and overlapping file access

Command line

  • AS (NORMAL | SYSDBA | SYSOPER) added to CLI connection information
  • Use -indirect to connect using the installed Oracle client (eg Oracle Instant Client), so you can connect using a service name
  • Connect via LDAP (eg -source user/password@host)
  • Connect with OS authentication (eg -source /@hostOrTNSName)


  • Saving an individual snapshot no longer fails to load schemas if no Oracle client is installed (partially fixed in last release)

Schema Compare engine updates

  • 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 - July 16th, 2014


  • Attempt to detect column renames. When a potential column rename is detected, an icon is shown next to the object name in the comparison results. 

    Column rename detection can be turned on or off in the project options. By default, rename detection is turned for new projects and off for projects created in earlier versions of Schema Compare
  • Populating from scripts progress messages now match those for live population

Command line

  • Command line options now match options in the GUI
  • TNS name lookup is now case-insensitive
  • SCO returns exit code 62 if the deployment fails
  • Abort-on-warnings option returns exit code 63 and aborts deployment if medium or high-level warnings occur during a /deploy run
  • Warnings are displayed in the command line


  • The Warnings page in the Deployment Wizard is shown if there are warnings to be reviewed
  • Warnings are no longer duplicated
  • Skip/Ignore warning for non-existent users is no longer ignored
  • Dropped table and dropped column data loss warnings are now high-level warnings


  • Saving an individual snapshot no longer fails to load schemas if no Oracle client is installed
  • A reports directory is now created on startup, preventing errors when you try to save reports without specifying a directory

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 - May 22nd, 2014


  • Improved support for materialized views (grants, complex queries, column aliases)
  • Removed connection timeout
  • Out-of-line constraints in Table SQL now supported - December 18th, 2013

Bug fixes

  • Exception and application exit no longer occurs when comparing snapshots

Version - November 19th, 2013

Bug fixes

  • "Ignore index names" option only considers unmatched objects as potential matches
  • SYS_NT tables are ignored 

Version - November 1st, 2013

Bug fixes

  • 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 - September 23rd, 2013

New feature

  • Support for nested tables

Bug fix

  • RELY DISABLE in scripts folders now backwards compatible 

Version - September 17th, 2013

Bug fixes

  • PL/SQL objects with quoted string literals appearing different after deployment
  • Scripts folder support for MVIEWS with subqueries

Version - September 12th, 2013

New feature

  • Option to ignore the NEXT clause value in materialized views 

Bug fixes

  • REFERENCES grant not appearing in correct order in deployment script
  • White space only comments not appearing in tables/views/columns
  • 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

Version - July 27th, 2013

  • Fix complex materialized views when comparing schema -> script folder
  • Fix aggregate materialized views when comparing schema -> script folder

Version - July 17th, 2013

  • Added Materialized Views
  • Added Materialized View Logs 

Version - July 8th, 2013

  • Fix context indexes appearing different
  • Fix external tables with unlimited external reject limit
  • Fix grants when schema names are different
  • Fix triggers which share their name with a SQL keyword 
  • Fix DR$ objects appearing in the comparison
  • Fix ordering of dependencies involving PLSQL objects
  • Added re-compilation of dependents to re-validate objects
  • Fix parallel progress dialog exceeding max value

Version - June 26th, 2013

  • Fix snapshot memory usage
  • Reduce memory usage when populating PL/SQL objects

Version - June 7th, 2013

  • Fix problem with ignoring column comments
  • Fix parallel progress task issues 

Version - June 4th, 2013

  • Run data source registration in parallel
  • OC-579 Ignore comments backwards compatibility fix
  • Package Bodies whitespace issue fix  

Version - May 28th, 2013

  • External tables support 
  • View parsing issue fix (semi-colons in string literals)

Version - May 14th, 2013

  • Improved support for storage clauses in script folders
  • New option to use only forward slash terminator in deployment script
  • Sequences now always created first and dropped last
  • Performance fix for bug introduced with
  • Comments that end in a single quote now scripted correctly

Version - April 26th, 2013

  • Added support for comparison and deployment of comments on tables, views and columns

Version - April 23th, 2013

  • Changed default action for adding a not null column to be "ignore issue"
  • Fixed crash in deployment wizard when deploying a subset of PL/SQL objects. 
  • Fixed check constraint matching where expression differed only by whitespace

 Script Folder Fixes: 

  • SQL with function arguments taking long time to read
  • Index-organized tables with custom index names
  • Function calls with 5+ part names
  • Function based indexes
  • Deeply nested left joins
  • PL/SQL Objects with comments before the object name
  • Order by clause in COLLECT

Version - April 8th, 2013

  • Fixed parsing of LISTAGG 
  • Fixed parsing of DECODE in IN conditions
  • Fixed SYS_PLSQL types appearing in comparisons on 10g 

Version - March 25th, 2013

  • Script folder fixes for GRANTs and optimizer hints

Version - March 19th, 2013

  • Split package headers and bodies
  • Script folder fixes for "overlaps" and DateTime literals

Version - March 8th, 2013

  • Xml function call in view parsing
  • Double dots in view
  • Extend trial length to 28 days

Version - January 25th, 2013

  • Fix crash when using "ignore index names" option
  • Fix comparison of scripts folders when schema names quoted
  • Fix for remapping a schema name with single quotes around it

Version - January 9th, 2013

  • Fix for scripts folders when specifiying lowercase target shema
  • Improved object difference view
  • New option for excluding schema names
  • Fix for bug with table rebuilds

Version - November 21st, 2012

  • Scripts folder trigger fixes
  • Scripts folder function based index fixes
  • Scripts folder sequence default fix
  • New option for ignoring index names
  • New option for ignoring log groups

Version 3.0 - November 14th, 2012

  • Scripts folder functionality (create, compare, and deploy to script folders)
  • "Test connection" button
  • UI improvements (eg larger, cleaner edit project dialog box)
  • Bug fixes (eg crash when deploying GRANTS)



Didn't find what you were looking for?