EMS logo

Products Navigation

Data Comparer for MySQL

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS Data Comparer for MySQL

On-line Documentation

Version history


 

Product name

Version

Release date

Data Comparer for MySQL

Version 3.4.0.1

March 7, 2012

Data Comparer 2011 for MySQL

Version 3.3.0.1

August 29, 2011

Data Comparer 2011 for MySQL

Version 3.2.0.1

March 21, 2011

Data Comparer 2010 for MySQL

Version 3.1.0.1

November 01, 2010

Data Comparer 2010 for MySQL

Version 3.0.0.1

May 04, 2010

Data Comparer 2010 for MySQL

Version 2.3.0.1

March 10, 2009

Data Comparer 2007 for MySQL

Version 2.2.0.1

October 2, 2008

Data Comparer 2007 for MySQL

Version 2.1.0.1

December 19, 2007

Data Comparer 2007 for MySQL

Version 2.0.0.1

February 5, 2007

Data Comparer 2005 for MySQL

Version 1.2.0.1

May 30, 2006

Data Comparer 2005 for MySQL

Version 1.1.0.1

March 14, 2006

 

 

Full version history is available at http://www.sqlmanager.net/products/mysql/datacomparer/news.

 

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.
  • 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.
  • The table comparison on the server side is now optional.
  • 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

 

  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.
  1. Added the possibility to synchronize BLOB fields in InterBase.
  2. Added the option for viewing the Summary for the compared objects at the Step 3 - Browsing data comparison results.
  3. Synchronization with deleting of records from tables containing foreign keys could result in an error. Fixed now.
  4. Added the possibility to clear the template list.
  5. 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

 

 

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
  • Tables for which the set of key fields differs from primary key fields are synchronized significantly faster now
  • Table lists are sorted by table 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
  • Implementation of Private Key support for SSH authentication
  • 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
  • Implemented support for UTF-8 encoding to perform data comparison
  • Added the Lock non-transactional MySQL tables option for data comparison and synchronization process

 

 

Version 1.2.0.1

 

  • Viewing/editing synchronization script with Script editor
  • The 'Drop and create indexes' synchronization option added
  • For the fields which are not in comparison the default values will be applied now (in previous versions NULL values were used)
  • Now it is possible to abort synchronization on error with the help of corresponding option
  • The console version of Data Comparer for MySQL now allows running the application in background mode

 

 

Version 1.1.0.1

 

  • New BLOB viewer
  • Higher speed of comparing process
  • The ability to view the connection information is added
  • The "Use only compare key for where clause" option is available at the specifying data synchronization options step now
  • The "Add computed and read-only fields to the new table" option is added
  • The ability to specify the appropriate client library is implemented
  • Primary key auto-setting for the fields to be compared
  • Color highlight for non-identical records is implemented
  • The "Commit after records" option is added

 

 

 


See also:

What's new