Generate comparison reports

Last modified: August 8, 2024

Data Compare for MySQL allows viewing and exporting the results of data comparison in the form of a report. The tool supports CSV, Excel, and HTML file formats for report generation.

The guide provides step-by-step procedures how to:

• Generate a report using dbForge Data Compare for MySQL
• Generate a report using the command line

Generate a report using dbForge Data Compare for MySQL

To generate a report with comparison results:

1. On the Comparison main menu, select Generate Comparison Report.

2. In the Comparison Report dialog that opens, select the report format: CSV, Excel, or HTML.

3. (For the CSV file format only) In the Folder field, enter the path to the folder to store the generated report.

4. (For the XLS and HTML file formats) In the File field, specify the file name for the generated report.

Note

The report in the CSV file format is generated as a set of files located in the folder. The report in the XLS and HTML file format is generated as a file and stored in the specified folder. To see the report layout and content in available file formats, see View comparison reports.

5. In the Comparison Report dialog, set up report generation options:

• Optional: Select the Append timestamp to the folder name checkbox to add date and time to the folder name.
• Optional: The View report on the completion checkbox is selected by default. To close the report on generation completion, clear the checkbox.
• In the Include section, select the objects you want to be displayed in the report. You can include All objects, Objects with differences, or Objects selected for synchronization in the report.
• (For the XLS and HTML file formats only) In the Options section, set up report options.

6. To generate the report, click Generate.

Generate a report using the command line

You can also generate a comparison report using the command line.

1. Click Start and search for cmd.

2. Type a path to the datacompare.com file located in the dbForge Data Compare for MySQL installation folder on your PC, and press SPACE.

3. Specify command line arguments: connection strings and actions you would like to run. For example, specify the type of the operation.

Note

To see a quick help on the arguments available in the command line, type the following:

dbforgesql.com /datacompare /?

4. Specify the objects that will be compared and synchronized.

5. Synchronize data directly into the database and generate a synchronization script file.

6. Generate a comparison and synchronization protocol into a file.

7. Compose a comparison report.

8. Specify the report format. You can choose between HTML and EXCEL.

9. Press ENTER to run the process.

For more information and examples, feel free to refer to Automate operations from the command line.