Schema Compare for Oracle (英語版) のリリース

Released: Mar 24, 2026

6.3.58 での更新項目

不具合の修正

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

Released: Mar 17, 2026

6.3.57 での更新項目

機能

  • 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.

不具合の修正

  • 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...

Released: Feb 19, 2026

6.3.54 での更新項目

機能

  • 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

6.3.53 での更新項目

機能

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

不具合の修正

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

Released: Feb 3, 2026

6.3.52 での更新項目

不具合の修正

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

Released: Jan 20, 2026

6.3.51 での更新項目

機能

  • 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.

不具合の修正

  • 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...

Released: Dec 18, 2025

6.3.49 での更新項目

機能

  • 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.

不具合の修正

  • 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.

Released: Nov 18, 2025

6.3.48 での更新項目

不具合の修正

  • Fixed an issue where Time Zone information was not being respected for schedule objects.

Released: Nov 18, 2025

6.3.47 での更新項目

機能

  • Added a comparison option to treat primary key constraints the same as those created by unique indexes.

不具合の修正

  • Fixed an issue where the engine incorrectly formats a script that exceeds the 2499 characters limit for a single line in SQL*Plus.
  • Fixed an issue where the engine failed to parse GRANT statements with DEBUG CONNECT privileges when reading from a scripts folder.

Released: Aug 8, 2023

6.1.x での更新項目

v6.1.0

Updated Aug 8, 2023

Features

  • Added support for time based Schedule objects.