Schema Compare for Oracle

Schema Compare for Oracle automatically compares and synchronizes the schemas of Oracle databases.

Published by Redgate Software
Distributed by ComponentSource since 2005

Prices from: US$ 475.20 Version: 6.3.x NEW Updated: Apr 28, 2026

Screenshot of Schema Compare for Oracle

Schema Compare for Oracle Releases

Released: Apr 28, 2026

Updates in 6.3.63

Fixes

  • Fixed an issue where object tables defined with a type from a different schema were scripted with the wrong schema qualifier in the OF clause.

Released: Apr 21, 2026

Updates in 6.3.62

Fixes

  • Fixed issue caused by extended UNICODE characters within string literals in script folders.
  • Fixed an object ordering issue in deployment scripts where "job to schedule" dependencies were not respected.

Released: Apr 9, 2026

Updates in 6.3.60

Features

  • Improved error message when encountering unsupported built-in data types.

Fixes

  • Fixed issue where LOCAL indexes on reference-partitioned tables were scripted with an incomplete explicit partition list, causing ORA-14024 on deployment.

Released: Mar 24, 2026

Updates in 6.3.58

Fixes

  • Fixed an issue where NOT NULL check constraints were still being scripted for Oracle GoldenGate columns.

Released: Mar 17, 2026

Updates in 6.3.57

Features

  • Added a new option to script a condition around GRANTs and REVOKEs to ensure that these statements are skipped if the grantee/revokee is the user running the deployment script.
  • Added a preview comparison option to add existence checks to scripts - currently supports index creation statements.

Fixes

  • Fixed a problem with the identification of 'grant to self' issues in deployment scripts.
  • Fixed an issue where the constraint index of an invisible virtual column was not being scripted out...
Read more

Released: Feb 19, 2026

Updates in 6.3.54

Features

  • Added a command line switch to ignore invisible indexes.
  • Added a comparison option to ignore invisible indexes.
  • Added support for extended unicode characters within object names in script folders.

Released: Feb 11, 2026

Updates in 6.3.53

Features

  • Added a comparison option to ignore invisible columns.
  • Added a command line switch to ignore invisible columns.
  • Comparison support for vector data types.

Fixes

  • Fixed a crash when selecting an empty snapshot in the Edit Project Dialog.

Released: Feb 3, 2026

Updates in 6.3.52

Fixes

  • Ignore columns with names that start with "CDRTS$". Relevant to Oracle Golden Gate generated columns.

Released: Jan 20, 2026

Updates in 6.3.51

Features

  • Added deeper support for JSON_VALUE syntax including ALLOW TO NUMBER CONVERSION.
  • Added support for tracking segment name for Lob storage in comparison and script generation.

Fixes

  • Fixed unexpected difference in XMLType columns with include storage options set.
  • Fixed an issue with nested table types where under certain scenarios they were not being populated correctly.
  • Fixed invalid SQL in deployment script when modifying storage options of an XMLType column.
  • Fixed an issue where Schema...
Read more

Released: Dec 18, 2025

Updates in 6.3.49

Features

  • Improved parser support for the "JSON_value_return_type"-clause syntax of the JSON_VALUE function.
  • Added support in the CLI for the new "index-related primary key construction differences" option.

Fixes

  • Fixed an issue where the tablespace property on XML_Type storage was not being generated correctly in some scenarios when deploying to a scripts folder.
  • Permissions on SCHEDULER JOB objects are now scripted out correctly.