Online Documentation for Data Comparer for Oracle

Added support for new server versions: SQL Server 2017, MySQL Server 8, PostgreSQL 12.
Support for Azure SQL Database implemented.
FB/IB. Fixed synchronization of TIME and DATETIME data types with milliseconds.
FB/IB. Support for BOOLEAN type implemented.
FB/IB. Triggers were not disabled correctly. Fixed now.
MySQL. The 'MySQL has gone away' error has been fixed.
PostgreSQL. The MATCH option is now processed correctly on creating FK.
Other fixes and improvements.

Version 3.5.1

Comparing and synchronization of big tables has been considerably improved.
The speed of comparing BLOB fields has been increased.
Now BINARY fields can be selected as key fields for comparison.
Field list was not refreshed on changing the tables. Fixed now.
The selected charset was not applied to the SQL-script. Fixed now.
The errors on loading the template file have been fixed.
Some other improvements and bug-fixes.

Version 3.5.0

Added the possibility to manually set a list of synchronized records.
Now it is possible to check for active triggers in the synchronized tables. If there are triggers in the target table, you will be prompted to disable them.
Added the possibility to set filters on the basis of the LIKE operator.
The console version of Data Comparer for Oracle did not connect to the server through the TNS_ADMIN environment variable. Fixed now.
Now at the "Setting tables correspondence" step a filter can be viewed as the pop-up window.

Version 3.4.0.1

Now the comparison results can be exported to MS Excel 2007.
The progress window now displays the time remaining and the number of records per second.
Data Filter. Added the OR and AND operations.
When selecting text fields as key fields, the table comparison speed significantly increased.
Added the possibility to save a template at any step of the wizard.
Some other improvements and bugfixes.

Version 3.3.0.1

Added the possibility to compare data using filters;
Added the "Trim CHAR Fields" option, which allows to trim spaces in CHAR and NCHAR fields while comparing and synchronizing data;
Added the Jump List with a list of templates for Windows 7;
If while synchronizing data, the number of records returned from the server is smaller than the expected amount to be synchronized (i.e. because of triggers), now a warning is written to the log-file;
Added the path parameter to the log file in the console version;
Some other improvements and bugfixes.

Version 3.2.0.1

RAM usage is optimized. Now the product consumes less memory when working with large tables.
Added the new option - ‘Fill correspondence automatically’ for the console version. When enabled, new tables in the database (created after generating a template) are also synchronized and compared when databases are compared.
When loading a template, the application can now ask for a password for the database if necessary.
Added the possibility to encrypt passwords in the template.
Sometimes table data were sorted incorrectly when displaying comparison results. Fixed now.
When synchronizing databases located on one server, it is now possible to generate synchronization scripts containing table data.
Added hints for options located on the application forms.
Other minor improvements and bugfixes.

Version 3.1.0.1

Added the ‘Disable foreign keys’ option on the Step 4 - Specifying data synchronization options which allows disabling foreign keys when inserting or modifying data.
The ‘Before synchronization script’ and ‘After synchronization script’ on the Step 7 - Specifying additional scripts are now executed in the same connection context where the synchronization is performed.
Script Editor. When saving and re-opening the editor, the character set chosen in the previous session is saved.
If any database errors occur during the comparison process, the program informs about errors and offers to continue. The error texts are displayed as a hint in the Summary dialog.
BLOB Editor. Added the possibility to view texts in Unicode.
The process of selecting tables to compare has become more convenient.
Added the possibility to disable the code folding in editors.
Added the possibility to export comparison results of all tables at once.
Added the possibility to use filters during the code completion.
Some other small bugfixes and improvements.

Version 3.0.0.1

The comparison and synchronization algorithm is significantly improved and is optimized for working with large databases:

The comparison speed is considerably increased, in some cases up to 5 times.
The synchronization speed is increased, especially in cases when compared tables are located on one server.
The amount of the consumed RAM is reduced, now it does not depend on the number of records in compared tables which allows avoiding the Out of Memory error.
The speed of auto-fill in tables and fields is increased.

Added the possibility to synchronize BLOB fields in InterBase.
Added the option for viewing the Summary for the compared objects at the Step 3 - Browsing data comparison results.
Synchronization with deleting of records from tables containing foreign keys could result in an error. Fixed now.
Added the possibility to clear the template list.
Some other small bugfixes and improvements.

Version 2.3.0.1

Added the Commit after synchronization option allowing to rollback all changes if an error occurs during the synchronization process.
Added the possibility to define table synchronization order manually.
Added the possibility to generate a summary report with table comparison results.
It is now possible to sort and filter comparison results.
Encrypted passwords within templates created with older versions of the utility could not be read properly. Fixed now.
Some other small bugfixes and improvements.

Version 2.2.0.1

Added tools for exporting comparison results to HTML and RTF
Added support of object tables
The new enhanced Script Editor
Added the possibility to output the detailed error description in the console application
Optimized the script generation mechanism: now only different fields are added to the synchronization script
Added tools for printing synchronization logs
Other minor improvements and bug-fixes

Version 2.1.0.1

Now you are able to set up SQL statement batches which will be executed before and/or after the synchronization process
The possibility to select DB schemas for data comparison is added
Tables for which the set of key fields differs from primary key fields are synchronized significantly faster now
Table lists are sorted by table and schema name now
The possibility to save synchronization logs to a file is implemented
The number of DB connections coincides with the number of selected threads
Other minor improvements and bug-fixes

Version 2.0.0.1

Multi-threading for data comparison
Boosted synchronization speed
A more convenient way of browsing differences in compared data
Implementation of the Find Text dialog in Script editor
Processing of Foreign keys implemented
An opportunity to select tables after data comparison
Export of comparison results to MS Excel documents
The ‘Detailed error messages’ option at the synchronization step
Encrypted passwords storage

See also:

What's new

The site SQLManager.net uses cookies, which is necessary for its full operation, including such functions as user authorization, purchase of products, collection of statistics of visits (excluding personal data), and others.

Click OK to continue browsing the site.