Generate comparison reports in CSV, Excel, or HTML

dbForge Data Compare for SQL Server allows you to view and export the results of data comparison in the form of a report. You may need this, for example, to produce a detailed report or to keep a record of the comparison results.

Generate a report

To export the full comparison results or a subset of the results:

1. On the menu bar, select Comparison > Generate Comparison Report.

2. Select a report format (CSV, Excel, or HTML), its location, and objects you want to include. For the description of the report formats, see CSV reports, Excel reports, and HTML reports.

3. Click Generate.

CSV reports

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.

Data Compare for SQL Server generates a separate CSV file for each selected table or view and for each row type included in the comparison.

Data Compare for SQL Server also creates a SummaryResults.csv file.

Excel reports

When you configure Excel report generation, you can choose to display the number of differences in each column and include the actual data records for objects with differences.

The following example shows the report.

HTML reports

When you configure HTML report generation, you can choose to display the number of differences in each column, include the actual data records for objects with differences, and include the comparison settings.

The following example shows the report.

Generate a report using the command line

To generate a comparison report from the command line, use the /report and /reportformat switches together:

1. Open Command Prompt.

2. Enter the command to compare the data and create a comparison report.

"C:\Program Files\Devart\Compare Bundle for SQL Server\dbForge Data Compare for SQL Server\datacompare.com" /datacompare /compfile:"<path_to_dcomp_file>" /report:"<path_to_comparison_report>" /reportformat:<report_format>

where:

• <path_to_dcomp_file> is the path to your .dcomp comparison project.
• <path_to_comparison_report> is the path to the folder to store the report.
• <report_format> is the format of the report: csv, xls, or html.

Note

If you installed dbForge Data Compare as part of dbForge SQL Tools, datacompare.com is located in C:\Program Files\Devart\dbForge SQL Tools\dbForge Data Compare for SQL Server by default.

3. Press Enter.

4. After the process finishes, view the generated report.