"EMS Data Comparer for SQL Server" is an efficient software that helps to compare and synchronize data quickly. The user can compare tables and rectify the differences by running a script automatically. The simple interface makes it easy to use.
One of the most impressive features of this software is its flexibility, allowing for customization of the comparison and synchronization process. Users can select tables and fields for comparison and tune a wide range of other options to suit their needs.
The program includes a graphical wizard that guides users through the comparison and synchronization process step-by-step. Additionally, a command-line service enables one-touch data synchronization for added convenience.
Key features of EMS Data Comparer for SQL Server include a user-friendly wizard interface, the ability to compare data for several tables at once, automatic and manual data selection options, wide range of synchronization parameters, partial data synchronization, the ability to save synchronization scripts to file for future use, and a configuration file for saving all defined parameters set during the current wizard session.
Overall, EMS Data Comparer for SQL Server is an excellent choice for anyone looking to streamline their data comparison and synchronization processes. With its ease of use and powerful features, this software is a must-have for businesses of all sizes.
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: now only different fields are added to the synch script
Version 2.0:
- Multi-threaded data comparison.
- Comparison logic has been optimized to increase synchronization speed.
- Private Key support for SSH authentication.
- Support for NCHAR, NVARCHAR, NTEXT data types.
- Browsing differences in data is now more convenient.
- Other improvements and bugfixes.
Version 1.2:
- Viewing/editing of synchronization script with Script editor is now available;
- The 'Drop and create indexes' synchronization option has been added;
- Other improvements and bugfixes.