dbForge Data Compare for Oracle History

5.5.183 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

5.5.182 21-Jun-24

User-reported bug fixes

Fixed a data synchronization issue that occurred when using the "Execute the script directly against the target database" option (D148673)
Resolved the application crash that occurred when an SQL document contained numerous UNIONs

5.5.172 19-Feb-24

User-reported bug fixes

Fixed an error that occurred when using the /schemas switch together with the /compfile switch in the command line (D127826, D137517)

5.5.100 21-Jul-23

Improvements

Added connectivity support for Oracle 23c

User-reported and internal bug fixes

Several user reported minor bugs are fixed

5.5.15 16-Mar-23

New features and improvements

Added support for Linux and macOS via CrossOver
Added the Ignore IDENTITY columns option for data comparison and synchronization
Added the /schemaexport and /schemaimport switches for command-line operations

User-reported bug fixes

Implemented the actual values of sequences in the data synchronization script (D103180)
Fixed a bug causing the application to crash upon launch (D95233)
Fixed an error that occurred when attempting to save a data comparison project with a name that exceeds system limits
Resolved an issue with manual product activation
Improved Data Viewer to allow for viewing large LOBs
Improved memory handling when viewing large sets of data in the Paginal Mode of the Data Editor
Fixed the highlighting of built-in functions

5.4.22 19-Jul-22

User-reported bug fixes

Fixed compatibility issues with the latest Windows 11 updates

5.4.15 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

5.4.13 04-Feb-22

User-reported bug fixes

Fixed an issue with comparing objects
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

5.4.7 13-Jan-22

New features and improvements

Added connectivity support for Oracle 21c
Improved the behavior of the Retrieve Data option
Updated the Data Comparison Report Wizard
Updated integration with version control systems

5.3.19 20-Oct-21

User-reported bug fixes

Fixed a critical error occurred when comparing data (D66961, D65979, D67984)

5.3.16 16-Jul-21

User-reported bug fixes

Data comparison error that occurred when working with BYTE columns
Mapping reset error during comparison with Custom Query
Other minor user-reported bugs are fixed

5.3.12 26-Jan-21

New features and improvements

Activation of the tool via the command-line interface

User-reported bug fixes

Several minor bugs are fixed

5.2.14 29-Sep-20

User-reported bug fixes

Several minor user-reported bugs are fixed

5.2.8 02-Jul-20

New features and improvements

Connectivity support for Oracle 20c is implemented
New 'Reseed identity column' data sync option is added

5.1.30 23-Dec-19

User-reported bug fixes

Other minor user-reported bugs are fixed

5.1.25 08-May-19

User-reported bug fixes

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

5.1.20 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 Error Report during comparison is fixed (T243422)
Problem with describe objects in Data Compare is fixed (ORCL-1658)
Other minor user-reported bugs are fixed

5.0.89 29-Dec-18

User-reported bugs fixed

Problem with "Manual Activation" button is fixed (T269117)
Incorrect description of database object is fixed
Other user-reported bugs are fixed

5.0.83 19-Nov-18

User-reported bugs fixed

Problem with activation is fixed

5.0.80 14-Nov-18

User-reported bugs fixed

Problem with XML DB is fixed (T268590)

5.0.76 30-Oct-18

User-reported bugs fixed

Data comparison issue is fixed (T264719)
Other user-reported bugs are fixed

5.0.44 25-Sep-18

User-reported bug fixes

Problems with database objects describing are fixed (T264461, T264719)

5.0.8 21-Aug-18

Support for new server

Oracle Database 18c connectivity support

Data Comparison Options

Specifying regular expression for:

Include tables or views by mask
Exclude tables or views by mask
Ignore columns by mask

Ignore whitespaces
Exclude newly added objects
Tolerance interval

Data Synchronization Options

Check for concurrency updates
Synchronize current values of sequences

Other Improvements

Expanded Comparison Reports functionality
Exclusion and Inclusion of columns from/into comparison
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

Invalid server name issue is fixed (T247359)
Problem with comparison key is fixed (T244201)
Problem with data sort is fixed (T184740)
Problems with Custom Query are fixed (T178768, T178420, T178416)
Null Reference Exception issue is fixed (T175905)
Other user-reported bugs are fixed (T243146, T247359, T234704, T228881, T211058)

4.0.29 24-Apr-17

Oracle Database 12c Release 2 connectivity support

4.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
Data type information to the column header in Data Grid added
Bugs fixed

4.0.17 10-Feb-16

Data Comparison UI significantly redesigned
Support connection to Oracle server via IPv6
Redesigned installation wizard

3.7.114 02-Feb-15

Data Comparison and Sync

Ignore difference in end of line option
Show white spaces option

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

3.6.110 31-Jul-14

Database Connectivity

Connection via Windows authentication is added
Windows connection coloring is added

Data Compare and Synchronization

Include Print Comments option is added
Use SQL *Plus Commands option is added

Data 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

3.5.89 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)

3.5.68 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

3.0.149 14-Aug-13

InvalidOperationException on working with SQL document in Express edition is fixed (T75878)

3.0.141 11-Jul-13

NullReferenceException on comparing BFILE data type is fixed (R23539)
NullReferenceException on working with an SQL document is fixed (T73600)
NullReferenceException on viewing unrepresentable data in the Data Editor is fixed (R22735)

3.0.127 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)

3.0.118 11-Jan-13

On opening Connection the ORA-00933 error is received (R14892)
Error on displaying connection editor form is fixed (T16315)
Error on recurring opening of the 'Custom Queries Mapping' dialog box is fixed (T63195)
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)

3.0.110 19-Nov-12

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)
Problem with updating data in a view with INSTEAD OF trigger on it is fixed (T60936)

3.0.85 25-Jul-12

Error "The path is not of a legal form" is fixed (T41834)
Problem with combo boxes in the synchronization wizard is fixed (R11372)

3.0.73 20-June-12

Error Report on dragging a document is fixed (T40368)

3.0.65 14-May-12

User-reported bug fixes

Error report during SQL script execution is fixed (R9055)
Problem with Ignore trailing spaces option in Data Comparison wizard is fixed (R9361)
Problem with disabled Data Editor is fixed (R9075)
Problem with parameter parsing in SQL document is fixed (R7852)

3.0.58 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)
NullReferenceException on mapping objects in Data Comparison wizard is fixed (R7172)
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)
ArgumentException on changing a schema in Data Compare document in the Express edition is fixed (T36990)
NullReferenceException on executing a statement in SQL Document is fixed (R7601)
NullReferenceException on editing data in Date columns in Data Editor is fixed (T36314)
OutOfMemoryException on mapping objects in Data Comparison wizard is fixed (R7717)
InvalidOperationException on comparing data through command line is fixed (R7720)
ArgumentException on comparing data is fixed (T36783, T37302)
Problem with showing errors in command line during data comparison is fixed (R7180)
Problem with creating report about comparison is fixed (T31803)
Path for comparison report is saved now (T37373)
Wrong behaviour with unstable network in Data Editor is fixed (T35784)
ArgumentException on comparing data is fixed (T37864)
InvalidCastException on editing DATE fields in Data Editor is fixed (R7325)
InvalidOperationException on comparing data through command line is fixed (R7096)
ExternalException on generating script of data comparison results is fixed (T34820)
NullReferenceException on comparing data through command line is fixed (R7008)

3.0.47 03-Feb-12

User-reported bug fixes

Null reference exception in command line is fixed (R7008)

3.0.43 7-Dec-11

User-reported bug fixes

Errors in the Command Line section of help are fixed (T32658)
Reestablishing connection after hibernation is added (T24429)
Behavior with Turkish locale is fixed (R1981)
Error report on describing in Oracle v8.05 is fixed (R2701)
Out of memory in Oracle v10.20 is fixed (R3291)

3.0.35 15-Aug-11

User-reported bug fixes

Problems with trial checking are fixed

3.0.34 03-Aug-11

User-reported bug fixes

The problem with showing a part of time for the DATE type was solved (T30268)
Possibility to exclude objects that are in the bin from comparison is added
Out of memory exception during data comparison is fixed
Combobox for selecting databases was removed from the SQL toolbar

3.0.27 5-Jul-11

User-reported bug fixes

Problem when trial period always expires was solved (T30400)

3.0.26 23-Jun-11

New extended data comparison reports

Possibility to analyze comparison results in the offline-mode due to export of real data into the report.
New Comparison Report wizard is added.
Possibility to include only columns containing differences for the rows that contain differences into comparison report.
Possibility to include the number of changes for each column into the comparison report.

Custom query result comparison

If you don't need to compare all data in your database, but need some customized comparison (for example, you need to see what has changed in your database over some period of time), you can compare the results of specific queries. For this, use the custom query result comparison feature available in the new version of the product.

More flexible comparison settings

"One-to-many" objects mapping can be used when some columns in the target database were separated as a table.
Possibility to include objects into comparison by mask. It is useful when you need to compare groups of tables.

Improved analysis of comparison results

Full-text data search
Possibility to hide unchanged columns in the result data grid.
The number of differences per column is now displayed on the status bar.

Improved data synchronization

Ability to omit schema name in the generated script file is added. It is required for better script portability.
Ability to restore session parameters in synchronization script is added.

Other improvements

Extended command line examples are added.
User interface skins support is added.
Start page is redesigned.

2.0.17 1-Mar-11

User-reported bug fixes

Fixed problem with LONG values reading (T26542)
Cannot use Direct connection without installed oracle client (T26440)
Add to synchronization script SET DEFINE OFF
Set option 'Hide System Schemas' enabled by default

2.0.10 9-Nov-10

User-reported bug fixes

Not to set a comparison key by all columns if table doesn't have primary or unique key.

2.0.9 22-Oct-10

User-reported bug fixes

Removed support of 32-bit Oracle clients under Windows x64 (55886)
Added support of .NET Framework 4.0 (55885)
False order of 'Commit' action in synchronization plan (55857)

2.0.8 05-Oct-10

New Features

Capability to compare several schemas at a time
Lots of comparison options: Ignore columns by mask, Ignore trailing spaces, Round float types, and more
Supported all Oracle's data types, except REF and object types
'WHERE clause' filter can be applied to any compared table
Views and materialized views can be included in comparison
Generating accurate comparison reports in HTML and Excel formats
Capability to change synchronization direction in one click
Lots of synchronization options: Disable triggers, Synchronize LOBs via files, Copy BFILEs, and more
Command line support to automate comparison and synchronization
Direct connection
Rollback synchronization on an error
Comparing data with different structures

1.0.15 07-Sep-10

User-reported bug fixes

Compatibility with 32-bit Oracle clients under 64-bit systems (T22679)
Double quoting single quotes in strings for DML statements

1.0.14 20-Aug-10

User-reported bug fixes

Added SQL*Plus' compatibility option 'SET SQLBLANKLINES ON' to synchronization script (T22294)
InvalidOperationException when open SQL file with no connection attached (54652)
Unable to save data to a file from Data Viewer tool window (54638)
Wrong values for TIMESTAMP WITH LOCAL TIME ZONE data type in the synchronization script (54631)

1.0.12 12-Aug-10

First release of dbForge Data Compare for Oracle