EMS Data Comparer for MySQL is a user-friendly software that allows for comparison and synchronization of data effectively. The software easily identifies differences between tables and provides an automated solution to resolve these disparities.
The software is extremely flexible, allowing you to customize the comparison and synchronization process just the way you want it. You can select the tables and fields you want to compare and tune many other options to match your specific needs.
Data Comparer for MySQL comes with a graphical wizard that guides you through the entire data comparison and synchronization process step by step. Additionally, it also includes a command-line service that enables you to synchronize data with a single touch.
The key features of this software include a user-friendly wizard interface, data comparison for several tables at once, automatic and manual selection of data to compare, a wide range of synchronization parameters, the ability to perform partial data synchronization, and the ability to save data synchronization scripts for future use.
Furthermore, you can save all the defined parameters you have set on the current wizard session, and there is even a command-line utility that allows you to compare and synchronize data using the configuration file.
In summary, EMS Data Comparer for MySQL is a must-have tool for anyone who needs to compare and synchronize data between different databases. The software is easy to use, highly customizable, and comes packed with a wide range of features to make the process as efficient and accurate as possible.
Version 3.0:
The comparison and synchronization algorithm is significantly improved and is optimized for working with large databases.
Added the option for viewing the Summary for the compared objects.
Added the possibility to clear the template list.
Some other bugfixes and improvements.
Version 2.3:
- Added the Commit after synchronization option allowing to rollback all changes if an error occurs during the synchronization process
- Manually define table synchronization order
- Generate a summary report with table comparison results
- It is now possible to sort and filter comparison results
Version 2.2:
Tools for exporting comparison results to HTML and RTF are added.
The new enhanced Script Editor.
Added the possibility to display the detailed error description in the console application.
The script generation mechanism is optimized: only different fields are added to the synch script
Version 2.1:
- Ability to set up SQL statement batches which will be executed before and/or after the synchronization process
- Faster sync for tables for which the set of key fields differs from primary key fields
- Table lists are sorted by table and schema name now
- Other improvements and bugfixes
Version 2.0:
- Multi-threaded data comparison.
- Comparison logic has been optimized to increase synchronization speed considerably.
- Support for UTF-8 encoded data.
- Private Key support for SSH authentication.
- Browsing differences in data is now more convenient.
- Other improvements and bugfixes.