XML Comparison Tool (Table)

The XML Comparison Tool is used to compare the structural and data differences between selected data tables and/or files. Table-to-Table, Table-to-File, File-to-Table and File-to-File comparisons can be made depending on the Original and New comparison modes you select.

To run an XML comparison against selected tables:

  1. In the Project Explorer, right-click on a data table and select Utilities | XML Comparison Tool.

  2. Set Original and New comparison options in the Table Xml Diff Options dialog:

Original

Mode

Select a comparison mode for the original tables or file you want to base a comparison on. When you run the comparison tool on a table, the mode defaults to Tables.

Mode Description
Tables Run the comparison on a selected data table or tables. Click the drop-down control to select additional Tables or change the table selection.
File Run the comparison on an XML file. Click on the ellipsis button to select the File Name.

New

Mode

Select a comparison mode for the new tables or file you want to compare against the original tables or file.

Mode Description
Tables Run the comparison on a selected data table or tables. Click the drop-down control to select additional Tables or change the table selection.
File Run the comparison on an XML file. Click on the ellipsis button to select the File Name.

Rename Mappings

An XML mapping transforms object data members to the XML elements of an XML file ...?

The Replace Mappings grid allows you to lookup values in the original XML and replace with other values in the new XML.

Add

To create a mapping:

  1. Click the Add icon to the right of the Mapping grid.

    Rename the new mapping to something meaningful by clicking New_Mapping1 to select it.

  1. Set the following parameters:

    2. Element

    The name of the parent element.

    Attribute

    An attribute of the parent element.

    Matching Value

    The value to match between the two XMLs.

    Replacement Value

    The replacement value to write to the new XML.

In the XML Comparison Window,

 

On the File tab, in the Operations group: Select Refresh Original to refresh the original comparison input.

On the File tab, in the Operations group: Select Refresh New to refresh the new comparison output.

To run an XML comparison against a scenario (case) see: XML Comparison Tool (Case)