dbForge Schema Compare for Oracle History

4.5.237 09-Jul-24

User-reported and internal bug fixes

Fixed the error that occurred when saving data to the clipboard (Ctrl+C) in the Data Editor

4.5.236 21-Jun-24

Fixed the behavior of reading and comparing table column comments (D135330)
Resolved an issue with displaying schema object differences for large source objects (D153716)

4.5.226 19-Feb-24

User-reported bug fixes

Enhanced the comparison algorithm for Access parameters in External tables, which previously could result in false differences (D136202)
Fixed an error that occurred when synchronizing indexes (D139792)

4.5.102 21-Jul-23

Improvements

Added connectivity support for Oracle 23c

User-reported and internal bug fixes

Fixed the loss of TABLESPACE and STORAGE OPTIONS during the synchronization of tables, indexes, and materialized views

4.5.17 16-Mar-23

New features and improvements

Added support for Linux and macOS via CrossOver
Improved the behavior of table columns reordering

User-reported bug fixes

Fixed an error that occurred when attempting to save a schema comparison project with a name that exceeds system limits (D110184)
Fixed an error that occurred when generating a script for columns with DEFAULT ON NULL (D100987)
Resolved an issue with manual product activation (D107637)
Improved the error diagnostics (D98041)
Resolved an issue with the synchronization between a column and a sequence
Fixed a bug causing the application to crash upon launch
Improved memory handling when viewing large sets of data in the Paginal Mode of the Data Editor
Improved the generation of the PCTFREE property synchronization script
Fixed the highlighting of built-in functions
Fixed a bug that occurred when describing partitions
Fixed a bug that occurred when generating DDL triggers

4.4.26 19-Jul-22

User-reported bug fixes

Fixed compatibility issues with the latest Windows 11 updates
Fixed an error that occurred when generating a comparison report from the command line (D80591)

4.4.20 23-May-22

User-reported bug fixes

Several minor user-reported bugs are fixed

4.4.19 28-Mar-22

User-reported bug fixes

Fixed an issue that blocked the program from being installed on specific environments due to the shell folder constant expansion failure
Fixed a critical error that occurred because of the editor cursor initialization failure when running under Microsoft Windows 11 Build 22567 and later
Fixed a critical error that occurred when painting the main window of the program on high resolution displays
Resolved an issue that caused the program license reactivation process after the BIOS update to fail

4.4.17 04-Feb-22

User-reported bug fixes

Fixed the behavior of the application installer when checking the version of the .NET Framework
Fixed an unexpected exception that occurred when closing a document that was modified in an external editor
Other minor user-reported bugs are fixed

4.4.9 13-Jan-22

New features and improvements

Added connectivity support for Oracle 21c
Added a new schema comparison option Ignore MAXVALUE
Added a new schema comparison option Ignore INCREMENT BY
Added a new schema comparison option Ignore CACHE
Added a new schema comparison option Ignore CYCLE
Drastically improved schema comparison reports
Improved the behavior of the Ignore START WITH schema comparison option

4.3.19 27-Oct-21

User-reported bug fixes

Fixed processing of differences in NOT NULL values for the PRIMARY KEY columns (D67520)

4.3.15 16-Jul-21

New features and improvements

Added ability to save * .dcomp and * .scomp files in the Comparison Wizard before running the comparison
Added ability to treat execution errors as warnings during schema synchronization

User-reported bug fixes

Fixed processing of differences in NOT NULL values for the PRIMARY KEY columns
Other minor user-reported bugs are fixed

4.3.11 26-Jan-21

New features and improvements

Activation of the tool via the command-line interface
Improved working with virtual columns when comparing and synchronizing schemas

4.2.18 29-Sep-20

User-reported bug fixes

Issue with the correct use of tablespaces in constraints when the Ignore Tablespaces option is enabled is eliminated (T306592)
Error occurred with describing columns (T304630, T304631)

4.2.12 02-Jul-20

New features and improvements

Connectivity support for Oracle 20c is implemented

4.1.28 23-Dec-19

User-reported bug fixes

Problem with generating sql script with table virtual column is fixed (T280712)
Other minor user-reported bugs are fixed

4.1.23 08-May-19

User-reported bug fixes

Problem with lost synchronization script is fixed (ORCL-2075)
Problem with foreign keys comparing is fixed (T282207)
Other minor user-reported bugs are fixed

4.1.18 16-Apr-19

New features and improvements

Brand New Application Skins
Support for Oracle 19c
AutoCommit Mode ON/OFF

User-reported bug fixes

Problem with default value and collation is fixed (T276888)
Problem with Generate Fully Qualified Object Name option is fixed (ORCL-1710)
Problem with incorrect temporal table name is fixed (ORCL-1920)
Other minor user-reported bugs are fixed

4.0.88 29-Dec-18

User-reported bugs fixed

Problem with option "Generate fully qualified object names" is fixed
Incorrect description of system properties is fixed
Materialized view creation issue is fixed
Other user-reported bugs are fixed

4.0.82 19-Nov-18

User-reported bugs fixed

Problem with activation is fixed

4.0.79 14-Nov-18

User-reported bugs fixed

Problems with connection to Oracle 12.1.0.1 are fixed

4.0.75 30-Oct-18

User-reported bugs fixed

Problems with special system table for full text search index are fixed (T243422, T243929)
Other user-reported bugs are fixed

4.0.43 25-Sep-18

User-reported bug fixes

Table rebuild issue is fixed (T243929)
Problems with database objects describing are fixed (T265092,T264461,264619)

4.0.8 21-Aug-18

Support for new server

Oracle Database 18c connectivity support
Support for Oracle 12c objects

Schema comparison options

Associate column names having similar name options
Disable dependency analysis
Ignore case in objects names
Ignore character length semantics
Ignore check constraints
Ignore collations
Ignore datatypes in column
Ignore Dependent Objects In Other Schemas
Ignore External Table Location Information
Ignore firing order for triggers
Ignore Flashback Archive
Ignore foreign keys actions ON UPDATE and ON DELETE
Ignore indexes
Ignore indexes' names
Ignore indexes present only in Target
Ignore INSTEAD OF Triggers
Ignore materialized view START WITH value
Ignore Parallel
Ignore primary keys
Ignore sequence MinValue
Ignore sequence START WITH value
Ignore spaces in objects names
Ignore Supplemental Log
Ignore Table DML Triggers
Ignore uniques

Schema synchronization options

Use DROP and CREATE instead of ALTER for tables
Use DROP and CREATE instead of ALTER for views, procedures, functions, triggers, packages, Java Sources

Other Improvements

Support for TEMPORARY TABLE
Expanded Comparison Reports functionality
Automatic selection of comparison key for object without equal unique indexes
Improved visual style of tool
Command line execution file wizard
Trial product activation
Support for PowerShell
Specific exit codes added
FIPS compliance

User-reported bug fixes

Automatic partitioning issue is fixed (T260470)
NullReferenceException issues are fixed (T259281, T262877)
Table rebuild issue is fixed (T243929)
Problem with "Save as my defaults" is fixed (T252343)
Table renaming issues are fixed (T243422, T243929)
Other user-reported bugs are fixed (T249138, T210706, T210706, T202941, T31026)

3.0.29 24-Apr-17

Oracle Database 12c Release 2 connectivity support

3.0.27 01-Nov-16

Greatly improved suggestion performance
Improved XML View and new JSON View for Data Editor and Viewer Window
Styled icons are used by default
Bugs fixed

3.0.17 10-Feb-16

Schema Comparison UI significantly redesigned
Support of complete range of TFS version control system from 2005 to 2015
Support connection to Oracle server via IPv6
Redesigned installation wizard

2.7.144 02-Feb-15

SQL Editing and Execution

Query execution pane
Command-line interface for SQL formatting
Option to set files encoding within the /execute command-line operation

Data Editor

Easy way to hide data results
Data Viewer and LOB Editor are combined in a single control
Redirect Data to Output is transformed into additional data editor

Other Features and Improvements

Create Schema Snapshot wizard window is modeless
Enhanced Find and Replace window
On-line documentation

2.6.140 31-Jul-14

Database Connectivity

Connection via Windows authentication is added
Windows connection coloring is added

Schema Compare and Synchronization

Ignore Schema Name During Comparison option is added
Ignore Compression Differences option is added
Ignore LOGGING/NOLOGGING Clause option is added
Ignore Column Order in Indexes option is added
Exclude Comments option is added
Use SQL *Plus Commands option is added

Data Editor and Viewer

Ability to view results as a structured XML file is added

User Interface

Switching tabs by the CTRL+ALT+PAGE UP and CTRL+ALT+PAGE DOWN keys combination
Restoring document tabs from the last session is possible now
Switching between wizard window and primary window is possible now

2.5.119 04-Dec-13

InvalidOperationException while editing query results is fixed (T89648)
IndexOutOfRangeException while connecting to Oracle 8.0.x is fixed (T88617)
Incorrect behaviour while setting custom keyboard shortcut for a command is fixed (T89000)

2.5.98 17-Oct-13

Oracle 12c is supported

New features of SQL Editor

Code completion is added
SQL Code Formatter is added

Minor features

Database objects are described faster now
New window docking system is introduced. Switching between tool windows on Ctrl+Tab is supported
Working with Oracle on Amazon RDS is possible now
New skins are added (Metropolis and VS2010)
Snapshot creation functionality is added
Microsoft Windows 8.1 is supported

2.0.192 14-Aug-13

InvalidOperationException on working with SQL document in Express edition is fixed (T75878)
NullReferenceException on creating snapshot via command line is fixed (T74698)

2.0.184 11-Jul-13

NullReferenceException on working with an SQL document is fixed (T73600)
An error while comparing a schema in Direct Mode is fixed (R18057)
NullReferenceException on viewing unrepresentable data in the Data Editor is fixed (R22735)

2.0.180 18-Jun-13

The problem with TFS in Schema Compare is fixed (T70020)

2.0.170 10-Apr-13

NullReferenceException on changing a date field in Data Editor is fixed (R17000)
Incorrect behaviour with inserting the Now value into the Timestamp field in Data Editor is fixed (R16260)
The problem with punctuation's visibility in code editor with black background being set is fixed (T64968)
Incorrect behaviour with editing selected text in code editor is fixed (R16116)

2.0.161 11-Jan-13

On opening Connection the ORA-00933 error is received (R14892)
Error on displaying connection editor form is fixed (T16315)
The Error on clicking MyDefaults in Schema Synchronization Wizard is fixed (R15446)
SET ROLE statement is supported (T61603)
Error occurring on the 'Paste As New Record' command execution is fixed (R8991)
The 'Empty path name is not legal' error on clicking Synchronize in the Synchronization wizard is fixed (R16854)
Notes for bookmarks in query results are added (T16548)
The 'Index was out of range' error on closing document is fixed (T62858)
Error on displaying results of several SELECT queries is fixed (T64570)
Message displayed on generating argument file is changed (T16317)
Error on opening window with subquery by foreign key is fixed (T63953)
Ability to set service name in connection manager is added (T62012)

2.0.153 19-Nov-12

Problem with hidden buttons in the Schema Comparison wizard is fixed (T14812)
Problem with launching the application through the command line via MSBuild is fixed (T41884, T40920)
ExternalException in GDI+ on typing text in SQL document is fixed (T42514)
Incorrect behaviour with removing the selected text in SQL document on closing the Edit Parameters dialog is fixed (T59896)
InvalidCastException on filtering data in Data Editor is fixed (T59944)
Incorrect determining of the DBA role for connected user is fixed (R14654)
Incorrect behaviour with cycled dependencies between object and table types during schema comparison is fixed (T59430)
Problem with updating data in a view with INSTEAD OF trigger on it is fixed (T60936)

2.0.128 25-Jul-12

Problem with new schema comparison window is fixed (T41812)

2.0.116 20-June-12

Error Report on dragging a document is fixed (T40368)

2.0.108 14-May-12

User-reported bug fixes

Schema synchronization scripts for Logging and Compress table options is fixed (T37909)
Error report during SQL script execution is fixed (R9055)
Problem with disabled Data Editor is fixed (R9075)
Problem with parameter parsing in SQL document is fixed (R7852)

2.0.106 23-Apr-12

New Features

Report generation options were added to Command line (T34566)

User-reported bug fixes

OutOfMemoryException on comparing big schemas is fixed (T38607)
Problem with constraints describe on Oracle 7 is fixed (T37308)

2.0.101 23-Mar-12

User-reported bug fixes

Issue when Error List isn't cleared on executing query with errors is fixed (R5686)
The problem with setting a filter for large fields in Data Editor is fixed (T35222, T35564)
Problem with hiding the "Loading Data" label is fixed (R6275)
OutOfMemoryException on toggling bookmarks in SQL document is fixed (R6055)
Incorrect behaviour with displaying bookmarks on editing text in SQL document is fixed (R6053)
Incorrect search of text occurrence in SQL Document is fixed (R6831)
NullReferenceException on executing a statement in SQL Document is fixed (R7601)
NullReferenceException on editing data in Date columns in Data Editor is fixed (T36314)
Few problems with showing differences in Schema Compare document are fixed (T31850)
ArgumentNullException on comparing schemas on a single connection is fixed (R6134)
NullReferenceException on closing Schema Compare wizard is fixed (R7095)
Problems with showing differences in Schema Compare document are fixed (T31850)
InvalidCastException on editing DATE fields in Data Editor is fixed (R7325)
NullReferenceException on comparing XML schemas is fixed (R7175)
Schema synchronization scripts are generated correctly now (T37909)
Wrong behaviour with unstable network in Data Editor is fixed (T35784)
Incorrect comparing of index properties is fixed (T37581)
Incorrect generation of records in log file during schema comparing is fixed (T36928)
Path for comparison report is saved now (T37373)

2.0.86 07-Dec-11

User-reported bug fixes

IndexOutOfRangeException on comparing schemas is fixed (T33255, T33283)
Determining CHAR and VARCHAR2 size is fixed (T32819)
Freezing on data comparison is fixed (T31698)
'Out of memory' error on x64 systems is fixed (T31317, T31735, T32846, T31917, R3870)
An error on *.scomp loading is fixed (R3742)
Incorrect identification of mapped objects in *.dcomp is fixed (R3739)
Incorrect navigation on the mapping page is fixed (R3737)

2.0.85 31-Oct-11

User-reported bug fixes

Invalid data type for virtual columns is fixed (T33244)
Index was out of range is fixed (T33255, T33283)
Incorrect behavior with circular reference in schema is fixed (T32784)
Incorrect SOURCE-object processing is fixed (T32728)

2.0.80 19-Sep-11

User-reported bug fixes

Semicolon duplication error in the end of Source Objects (T31635)

2.0.77 15-Aug-11

User-reported bug fixes

Problems with trial checking are fixed

2.0.73 29-Jul-11

User-reported bug fixes

Possibility to exclude objects that are in the bin from comparison is added
Out of memory exception is fixed
Combobox for selecting databases was removed from the SQL toolbar

2.0.71 1-Jul-11

User-reported bug fixes

Incorrect working with virtual columns is fixed
Incorrect working with comment objects is fixed
Exception in Standard edition during comparison is fixed (T29721, T30350)
Problem with displaying system indexes for nested tables is fixed

2.0.62 06-Jun-11

User-reported bug fixes

Incorrect working with indexes in DBA mode is fixed

2.0.59 02-Jun-11

New Features

Database comparison and synchronization via command line
Capability to create schema snapshots and compare them with each other or with a database
Version control system integration for database change tracking
Synchronization of object permissions
Support for cluster tables and Java Source objects
Comparison and synchronization of wrapped objects
New comparison options: Ignore Permissions, Compare Wrapped vs Unwrapped PL/SQL Objects
New synchronization options: Purge Recycle Bin
Start page improvement
Support for Oracle 11 R2 Express Edition

User-reported bug fixes

Incorrect synchronization of COMMENT OBJECT is fixed (T28059)
Incorrect working with triggers is fixed
Working with server that is turned off is fixed (T27463)
System.InvalidCastException during comparison process is fixed (T27849)
Exception on external editing of *.scomp file is fixed (T28059)
Examples on command line usage are added to documentation (T28207)

1.00.183 23-Feb-11

First release of dbForge Schema Compare for Oracle