Generating the comparison report

Data Compare for SQL Server allows viewing and exporting the results of data comparison in the form of a report. You may need that, for example, to produce a detailed report, or to keep a record of the comparison results.

Generating a report

To export the full comparison results, or a subset of the results, to a collection of comma-separated value (CSV) files:

1. Click Comparison on the main menu bar and then select Generate Comparison Report.

Generate report

2. In the Generate Comparison Report dialog window that appears select a report format (CSV, Excel, or HTML), its location and objects you want to report.

CSV report

3. Click Generate.

You can create a report in one of three formats:

CSV report

A Comma Separated Values (CSV) file is a plain text file that contains a list of data. These files are often used for exchanging data between different applications.

For each selected table or view and for each of the row types that you selected to include into synchronization, Data Compare for SQL Server creates a separate CSV file.

CSV report

Data Compare for SQL Server also creates a SummaryResults file.

SummaryResults file

Excel report

When configuring an Excel report generation, you can select to show the number of differences per column and include actual data records for different objects.

The report has the following view.

Excel report

HTML report

When configuring an Excel report generation, you can select to show the number of differences per column, include actual data records for different objects, and include comparison settings.

The report has the following view.

HTML report