Schema Compare for Oracle 6

Schema Compare for Oracle 6.3 release notes

Version 6.3.45 - September 29th, 2025

Features

  • Alters the effect of the Ignore system partitions option so that for Hash partitioned tables the quantity of any system named partitions will be taken into account in comparisons, but the names and other details of those system named partitions will be ignored.

Fixes

  • ZD-336765: Added parser support for TYPE(LAX) and TYPE(STRICT) in JSON_QUERY and JSON_VALUE
  • Raise Drop Partition warnings in deployment scripts that rebuild a partitioned table into a standard table.

Version 6.3.44 - September 17th, 2025

Features

  • Upgrade .NET Framework version to 4.8

Version 6.3.43 - September 2nd, 2025

Features

  • Adding or dropping range partitions on a table (but not both at once) no longer causes a table rebuild.

Version 6.3.42 - August 19th, 2025

Features

  • Certain table and partitioned table rebuild scenarios in deployment scripts will use a Create Table As Select (CTAS) approach.

Fixes

  • ZD-334351: Fix "An item with the same key has already been added" when deploying a constraint with an existing backing index and source/target schemas are identical

Version 6.3.41 - August 11th, 2025

Features

  • Internal library updates

Version 6.3.40 - August 6th, 2025

Fixes

  • ZD-335107: Fixed an issue where the engine incorrectly reported a difference for a Schedule where start_date, end_date or repeat_interval were null

Version 6.3.39 - July 22nd, 2025

Features

  • Added a warning indicating that support for Oracle 11G and 11G2 will be dropped in a future version of Schema Compare for Oracle.

Version 6.3.38 - July 10th, 2025

Features

  • Altering certain list partition properties no longer causes a table rebuild.

Fixes

  • ZD-307891: Fixed an issue where the engine creates a duplicate unique index when referencing an invisible column with unique constraint

Version 6.3.37 - July 1st, 2025

Fixes

  • ZD-333164: Don't generate SQL for system generated partitions when using the Ignore System Partitions option

Version 6.3.36 - June 17th, 2025

Features

  • Internal library updates

Version 6.3.35 - June 13th, 2025

Fixes

  • ZD-333164: Fixed an issue where invalid SQL was generated for table partitions when using the Ignore System Partitions option

Version 6.3.34 - June 10th, 2025

(Note: this release has been pulled)

Features

  • Dropping list partitions on a table, when not adding or altering other partitions on it, no longer causes a table rebuild.

Version 6.3.33 - June 3rd, 2025

Features

  • Adding list partitions on a table, when not dropping or altering other partitions on it, no longer causes a table rebuild.

Version 6.3.32 - May 27th, 2025

Features

  • Added support for handling BINARY XML storage type

Fixes

  • ZD-327929: Fixed an issue around showing "CLOB" instead of "BINARY XML" in the diff window

Version 6.3.31 - May 21st, 2025

Features

  • Internal library updates

Version 6.3.30 - May 12th, 2025

Features

  • Internal library updates

Version 6.3.29 - May 1st, 2025

Features

  • Internal library updates

Version 6.3.28 - April 17th, 2025

Features

  • Internal library updates

Version 6.3.27 - April 8th, 2025

Features

  • Internal library updates

Version 6.3.26 - March 25th, 2025

Features

  • Internal library updates

Version 6.3.25 - March 11th, 2025

Features

  • Internal library updates

Version 6.3.24 - February 24th, 2025

Features

  • Internal library updates

Version 6.3.23 - February 6th, 2025

Fixes

  • ZD-318165: Changed encoding so the scripts folder now stores unescaped characters

Version 6.3.22 - January 28th, 2025

Fixes

  • ZD-316728: Fixed issue where we were attempting to drop indexes that shared a name with a constraint but were created manually
  • ZD-311607: Fixed issue where package names in trigger text was not scripted correctly when used with public synonyms causing a difference after deployment

Version 6.3.21 - January 22nd, 2025

Features

  • Internal library updates

Version 6.3.20 - January 14th, 2025

Features

  • Internal library updates

Version 6.3.19 - January 7th, 2025

Fixes

  • ZD-307699: Fixed issue where primary key was attempting to be dropped from a materialized view without a primary key

Version 6.3.18 - December 17th, 2024

Fixes

  • ZD-318479: Fixed issue where differences were being caused by use of SQL Keywords in Index table column names

Version 6.3.17 - December 12th, 2024

Fixes

  • ZD-311652: Fixed parsing for the unicode replacement character and some other previously unsupported characters

Version 6.3.16 - December 3rd, 2024

Features

  • Internal library updates

Version 6.3.15 - November 27th, 2024

Fixes

  • Removed the option to compare Flyway toml projects

Version 6.3.14 - November 20th, 2024

Fixes

  • ZD-299121: Fixed bug that caused User Object Privileges to be granted in deployment scripts before the object was created in some scenarios

Version 6.3.13 - November 13th, 2024

Features

  • ZD-313837: Added a new comparison option to ignore the INCREMENT BY property of SEQUENCE objects.
  • ZD-313837: Added a new comparison option to ignore the MINVALUE property of SEQUENCE objects.
  • ZD-313837: Added a new comparison option to ignore the MAXVALUE property of SEQUENCE objects.
  • ZD-319118: Resolved an issue with connecting to Oracle 19 and higher in Direct mode when using Oracle Encryption or Oracle Data Integrity

Version 6.3.12 - October 29th, 2024

Features

  • Internal library updates

Version 6.3.11 - October 24th, 2024

Fixes

  • ZD-307181: Fix missing column definitions for generated scripts when using INMEMORY tables

Version 6.3.10 - October 15th, 2024

Features

  • Internal library updates

Version 6.3.9 - September 26th, 2024

Fixes

  • ZD-309223: Prevent scripting of LOB clauses for extended RAW columns.

Version 6.3.8 - September 17th, 2024

Fixes

  • ZD-312075: In comparisons, ignore case differences of conditional compilation flags for PL/SQL functions, triggers, packages and package bodies

Version 6.3.7 - September 12th, 2024

Features

  • Internal library updates

Version 6.3.6 - August 27th, 2024

Fixes

  • ZD-307606: Prevent scripting of LOB clauses within PARTITION statements for extended datatypes.
  • ZD-316431: Fix for a perpetual difference on Local index storage due to PCTINCREASE.

Version 6.3.5 - July 25th, 2024

Features

  • Internal library updates

Version 6.3.4 - June 11th, 2024

Fixes

  • Additional fixes to ensure directory names in DEFAULT DIRECTORY statements are treated as identifiers there-by start quoting them accordingly when storing them in the script folders
  • Changed the name of sco.tar.gz to include the version number

Version 6.3.3 - April 9th, 2024

Features

  • Increased DEBUG logging detail for constraint population

Version 6.3.2 - March 19th, 2024

Fixes

  • ZD-304493: Fixes the missing name quoting for directory names in an external table definition

Version 6.3.1 - February 27th, 2024

Compatibility with Data Compare for Oracle 6.3.1

Version 6.3.0 - January 16th, 2024

Features

  • Added a new log level setting: Information
  • Allows a flyway.toml Flyway configuration file to be opened in place of a Schema Compare for Oracle project file

Didn't find what you were looking for?