Generate comparison report

After running the comparison, you can generate a comparison report in dbForge Schema Compare for MySQL to export the results.

1. In the Comparison menu, click Generate Comparison Report.

Generate Comparison Report

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

Comparison Report

3. Click Generate.

Tip

If you want to open the comparison report after generation, select View a report on completion.

You can create a report in one of the following formats:

Interactive HTML

By clicking an object, you can inspect the differences in the object creation scripts.

The HTML report contains the following information:

  • Date of generation
  • Source and Target details
  • Comparison Results in the form of the list
  • Comparison and Synchronization Options
  • Synchronization script
  • Warnings

HTML Report

Excel

An Excel report does not show comparison options.

Excel Report

XML

The XML report is an XML file listing the date of generation, Source and Target details, comparison options selected, comparison summary, and results.

XML Report

Excel XML spreadsheet

Schema Compare also allows the creation of a comparison report in XML Spreadsheet 2003 file format.

To create a report in Excel XML Spreadsheet format:

1. In the Generate Comparison Report dialog, select XML format.

2. Click to select Use XML Spreadsheet 2003 file format.

Create XML to Excel Report

3. Click Generate.

XML to Excel Report

Generate a report from the command line

Schema Compare for MySQL enables you to generate a comparison report from the command line.

1. Click the Start button and search for cmd.

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

3. Define what action you would like to perform, for example: /schemacompare.

4. Type all the arguments (actions you want to run) and parameters in the Command Prompt.

Tip

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

/schemacompare.com /?

5. Define Source and Target connection strings.

6. To generate and save a comparison report file, specify the file name and location. For example:

/report:"C:\Report.html"

For more information and examples, refer to Automate schema comparison and synchronization from the command line.

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Schema Compare for MySQL.
Request a demo

Request a demo

If you consider employing the Schema Compare for your business, request a demo to see it in action.
Ready to start using dbForge Schema Compare for MySQL?
Download a free 30-day trial