EMS Data Comparer for SQL Server

What is EMS Data Comparer for SQL Server?

EMS Data Comparer for SQL Server is a powerful and easy-to-use tool for sql server data comparison and synchronization. Using this utility, you can view all the differences in the compared SQL Server tables and run an automatically generated script to eliminate those differences.

Flexible customization of the SQL Server comparison and synchronization process will allow you to select tables and fields for comparison, perform partial SQL Server data synchronization, or compare data to multiple tables at the same time, and adjust many other options to effectively compare sql server table data. The Data Comparator for SQL Server includes a graphical wizard that will walk you step-by-step through the SQL Server data comparison and synchronization process and a command-line utility to synchronize SQL Server data with one touch.

Core features

• Wizard-friendly interface.
• Comparison of data for multiple tables at the same time.
• Automatic and manual selection of data to compare.
• Data comparison filters.
• Wide range of synchronization parameters.
• Partial synchronization of data.
• Saving the Data Sync Script to file for future use.
• Saving all parameters defined in the current wizard session.
• Command-line utility to compare and synchronize data using the configuration file.
• Support for all sql server data types.
• Amazon RDS support for SQL Server, Azure SQL database.

System requirements

Microsoft Windows XP, Microsoft Windows Server 2003, Microsoft Windows Server 2008, Microsoft Windows Server 2008 R2, Microsoft Windows Server 2012, Microsoft Windows Server 2012 R2, Microsoft Windows Server 2016, Microsoft Windows Vista, Microsoft Windows 7, Microsoft Windows 8 / 8.1, Microsoft Windows 10

512 MB of RAM or more

50 MB of available HD space for program installation

MDAC (Microsoft Data Access Components) ou SQL Server Native Client

Possibility to connect to any local or remote SQL ™ Server