Schema Compare for Oracle 6

Schema Compare for Oracle 6.3 release notes

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?