Schema Compare for Oracle 新版本发表

Released: Apr 9, 2026

6.3.60 中的更新

特性

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

修补程序

  • 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

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

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

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.