FAQ

EMS Data Comparer for SQL Server is a powerful and easy-to-use utility for data comparison and synchronization which allows you to view differences in tables and execute an automatically generated script to synchronize data between these tables. Data Comparer for SQL Server includes a GUI wizard which guides you through the data comparison and synchronization process step by step, and a command-line version for synchronizing data in one-touch.

First of all you must have an opportunity to connect to some local or remote SQL Server. Besides you need your computer to satisfy the system requirements of EMS Data Comparer for SQL Server.

You can configure the template files visually using the Data Comparer Wizard. Set all the necessary options in each step of the wizard and click the Tools | Save template button. All the options will be saved to the template file which can be used afterwards in the console application.

If you have already purchased Data Comparer, you can register the product by entering the appropriate registration information.
Please refer to How to register EMS Products for details.

The trial version of the utility allows to compare and synchronize no more than 10 tables. As for the rest, the functionality of the trial version does not differ from the full one. You can test the features implemented in Data Comparer within the 30-day trial period for free.

Follow all steps of the wizard setting the necessary parameters and save the project template at the last step of the wizard. The template can be launched from the command line of the console version of the utility. To schedule the project, set the console version run with the template name as a parameter, using the standard Windows Task Scheduler.