Comparing Metadata

You can compare two metadata sources. You can compare metadata differences between two Oracle Data Relationship Management applications, between two XML files, or between a Data Relationship Management application and an XML file. You can generate an XML file containing the differences between the two metadata sources. The results can be used to restore data, undo unauthorized changes, or find wrong object type configurations.

You can generate a report from the information in the XML file that is created.

To compare metadata:

  1. On the Main Menu, click Difference.
  2. From the Source #1 drop-down list, select the type of source: Server Connection or XML File.
  3. Do one of the following:
    • If you selected Server Connection, enter Data Relationship Management connection information and click Log In.

    • If you selected XML File, click Browse and select the XML file that you want to use in the comparison and click Upload.

  4. If you uploaded a file, review the uploaded file information and click Next. Otherwise, skip to the next step.
  5. Repeat steps 2–4 for Source #2.
  6. Click Next.
  7. Select the object types to include in a difference file by using the following actions:
    • Select a filter

    • Click > to select a object type from Source #1.

    • Click < to select a object type from Source #2.

    • Click X to deselect a object type.

    • Click the left column header to select all objects from Source #1 based on the selected filter.

    • Click the right column header to select all objects from Source #2 based on the selected filter.

    • Click the center column header to deselect all objects based on selected filter.

    • Click the page links at the top of the compare results to switch to a different page.

    Note:

    Page size allows you to define the number of object types to view on a page.

  8. Click Create Difference File.
  9. Do any of the following:
    • Click Download the Metadata Difference File to open or save the XML file.

    • Click View the Metadata Difference File to view the XML file details.

    • Click Load the Metadata Difference File to load the file into an Data Relationship Management application. For more information, see Loading Metadata.

    • Click Generate Reports for the Metadata File to generate a report from the XML file. For more information, see Generating Reports.