Studio for SQL Serverprovides a possibility to view results of data comparison in the form of a report.
To generate a comparison report after comparison, perform the following steps:
Click Comparison on the menu bar and then click Generate Comparison Report. The Comparison Report wizard opens.
On the Format page, select the required report format (HTML, Excel, or CSV).
Specify the name of the report file.
Specify the location of the report file.
Check the View the report on completion check box to view the report upon creation.
On the Options page, select the required options.