Generate a comparison report

After you generate a schema comparison project file (.scomp), you can create a comparison report to export the results.

To generate a comparison report:

1. Open the Comparison Report dialog in one of these ways:

  • In the top menu, select Comparison > Generate Comparison Report.

  • On the Comparison toolbar, click Generate Comparison Report Generate Comparison Report.

2. In the dialog:

  • Choose a file format: HTML, Excel, or XML.
  • Specify the file name, or click the ellipsis button to choose the folder and specify the name of the comparison report.

Warning

The file name cannot contain any of the following characters: ", *, /, :, <, >, ?, \, and |.

  • Optional: Configure the options for the comparison report.

Comparison report dialog

3. Click Generate.

Tip

To open the comparison report after generation, select View report on completion.

Comparison report options

The table lists the options you can configure to customize the comparison report.

Name Description File format Default state
Append timestamp to the file name Adds the current date and time to the file name. HTML
Excel		 Off
View report on completion Opens the report automatically after it is generated. HTML
Excel		 On
All objects Includes all objects in the comparison report. HTML
Excel		 Off
Filtered objects Includes only those objects that meet the filter rules. HTML
Excel		 On
Objects with differences Includes objects from the Different section. HTML
Excel		 Off
Objects selected for synchronization Includes objects that are selected for synchronization in the schema comparison document. HTML
Excel		 Off
Compare and sync options Includes comparison and synchronization options. HTML
XML		 Off
Warnings Includes warnings that appear during comparison or synchronization. HTML On
Deployment script Includes a synchronization script. HTML On
Use XML Spreadsheet 2003 file format Generates a comparison report in the XMLFOREXCEL file format. XML Off
Removed-added lines Highlights statements that will be removed or added, or objects from the Different section. HTML On
Crossed out words Displays removed statements with strikethrough formatting and added statements with highlighting. HTML Off

Save command-line settings to a .bat file

You can create a .bat file with the command-line settings to automate or schedule schema comparison and synchronization.

To save command-line settings to a .bat file:

1. In the lower-left corner of the Comparison Report dialog, click Save Command Line.

2. In the Command line execution file settings dialog, configure the command-line settings.

3. To verify the settings, click Validate.

4. Click Save to save the file.

For more information about command-line options, see Additional schema compare arguments.