Online Documentation for SQL Management Studio for SQL Server
Running Data Comparer
EMS Data Comparer for SQL Server is a powerful and easy-to-use utility for data comparison and synchronization. With flexible customization of the comparison and synchronization process you can select tables and fields for comparison and tune many other options.
Data Comparer for SQL Server provides you with a Wizard which guides you through all the steps of data comparison and synchronization process: you can view all the differences in tables being compared and execute an automatically generated script to eliminate these differences.
Additionally to the GUI version which is implemented in the form of a Wizard application, Data Comparer for SQL Server includes the console version which is intended for running from Windows command line with a template file name used as the execution parameter.
To run Data Comparer for SQL Server, click its icon or caption on the Desktop Panel and follow the steps of the Wizard. If necessary, you can click the Arrow-down button to open the menu allowing you to specify a template, and run the wizard/console with the template.