Schema Compare for Oracle 릴리스

Redgate Software데이터베이스 비교 도구
버전 6.3.x (2026년 9월 15일)

릴리스 전반에서 새로 나온 내용을 살펴보세요. 기능, 개선 사항, 해결된 문제에 대한 자세한 정보를 제공합니다.

1월
2월
3월
4월
5월
6월
7월
8월
9월
10월
11월
12월
Schema Compare for Oracle 6.3.752026년 9월 15일
기능
  • Internal library updates.
Schema Compare for Oracle 6.3.732026년 8월 25일
기능
  • Added "o"/"objectexistencechecks"/"object-existence-checks" value for the CLI behavior switch to expose this new (in preview) option.
수정 사항
  • Fixed comparisons involving a snapshot incorrectly showing a primary or unique key's backing index as a standalone object, or as inline, when the snapshot was captured with a different "Ignore index-related primary key construction differences" setting than the one active for the comparison.
Schema Compare for Oracle 6.3.722026년 8월 18일
기능
  • Added support for comparing and deploying changes to Oracle native JSON columns.
수정 사항
  • Enabling the "Ignore index-related primary key construction differences" option no longer changes how a primary or unique key is represented when its backing index simply shares the constraint's name. Previously the option promoted that index to a standalone object, which reported an index that had no file in the scripts folder, showed a USING INDEX clause the scripts folder did not contain, and queued up a change for every affected table as soon as the option was turned on.
Schema Compare for Oracle 6.3.692026년 7월 31일
기능
  • Introduced new IncludeOnlineIndexCreation option in the UI and CLI to add 'ONLINE' clause to index creation scripts.
  • Cross-schema object permissions are now recorded only against the object's owner instead of against both the owner and the grantee. This stops the same grant being duplicated across two schemas (a common cause of drift when each schema is in its own project) and prevents deployment scripts from generating grants that the connected user cannot execute. Where the owner schema is outside the comparison, a grant that an in-scope object genuinely depends on is still kept so that object can deploy - a REFERENCES grant backing a foreign key, or a grant on an out-of-scope table or type used by an in-scope view, package or column. Grants on objects no schema owns (directories, editions and users) are unaffected and remain recorded against the grantee.
수정 사항
  • Text objects with lines longer than 2499 characters can now be deployed correctly.
Schema Compare for Oracle 6.3.682026년 7월 23일
기능
  • Added initial support for the Oracle native JSON data type.
  • Added support for comparing and deploying Oracle Scheduler Job Arguments.
수정 사항
  • Fixed a crash when scripting a table whose foreign key references a table that is not present in the schema model.
  • Fixed an issue with some schema names being handled inconsistently, causing spurious object differences when "Ignore schema names" was enabled and producing schema references with the wrong casing, thus showing up as differences.
Schema Compare for Oracle 6.3.672026년 7월 1일
기능
  • Narrowing the length of a VARCHAR2, NVARCHAR2 or RAW column is now deployed with a targeted UPDATE and ALTER TABLE MODIFY instead of a full table rebuild, where the column has no dependents that would prevent an in-place modification.
수정 사항
  • Fixed tables with a system-generated primary key index being incorrectly reported as different (with the index shown as existing only in the scripts folder) when comparing a scripts folder to a database with the "Ignore index-related primary key construction differences" option enabled.
  • Improved the error message shown when LOB population fails with 'ORA-65047' because the 'XML_TAB_COLS' data dictionary views are invalid (for example on Oracle 'lite' images where the XDB component is not fully installed).
Schema Compare for Oracle 6.3.662026년 6월 3일
기능
  • Added support for comparing and deploying parameter changes to Oracle VECTOR columns. Deployment uses a table rebuild, which drops the vector column data.
수정 사항
  • Fixed a regression where comparing two snapshots with cross-schema privilege changes produced duplicate permissions.
  • Fixed object existence checks producing invalid scripts when object names, owners, column names or column defaults contained single quotes.
Schema Compare for Oracle 6.3.652026년 5월 21일
기능
  • Existence checks on adding and dropping table columns are now supported in preview.
수정 사항
  • Fixed an issue where altering a materialized view log from INCLUDING NEW VALUES to EXCLUDING NEW VALUES produced a script that did not change the target.
Schema Compare for Oracle 6.3.642026년 5월 12일
기능
  • Added snapshot support for the Oracle 23ai VECTOR data type.
  • Existence checks on creates and drops for the following objects are now supported in preview:
    • Functions.
    • Indexes.
    • Jobs.
    • Materialized views.
    • Materialized view logs.
    • Packages.
    • Procedures.
    • Queues.
    • Queue Tables.
    • Schedules.
    • Sequences.
    • Synonyms.
    • Tables.
    • Triggers.
    • Types.
    • Views.
수정 사항
  • Fixed an issue where Time Zone information was not being respected for job objects.
  • Fixed issue where adding a column to an existing unique constraint backed by a separately-defined index produced duplicate DROP UNIQUE and ADD CONSTRAINT statements, causing ORA-02442 on deployment.
Schema Compare for Oracle 6.3.632026년 4월 28일
수정 사항
  • 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.
Schema Compare for Oracle 6.3.622026년 4월 21일
수정 사항
  • 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.
Schema Compare for Oracle 6.3.602026년 4월 9일
기능
  • 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.
Schema Compare for Oracle 6.3.582026년 3월 24일
수정 사항
  • Fixed an issue where NOT NULL check constraints were still being scripted for Oracle GoldenGate columns.
Schema Compare for Oracle 6.3.572026년 3월 17일
기능
  • 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.
Schema Compare for Oracle 6.3.542026년 2월 19일
기능
  • 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.
Schema Compare for Oracle 6.3.532026년 2월 11일
기능
  • 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.
Schema Compare for Oracle 6.3.522026년 2월 3일
수정 사항
  • Ignore columns with names that start with "CDRTS$". Relevant to Oracle Golden Gate generated columns.
Schema Compare for Oracle 6.3.512026년 1월 20일
기능
  • 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 was incorrectly reporting a difference for changes in case for comment statements and alter views in a script folder.