Filtering and sorting differences in the Compare editor

When you compare and merge data objects in the Compare editor, you can filter and sort the differences.

About this task

Filter differences in the Compare editor to simplify the view. Objects that are filtered from the comparison do not appear in the Compare editor.

Sort differences in the Compare editor to simplify the display of objects in the editor and to make it easier to find objects with differences.

Restriction:
  • Exported changes are not affected by filtering or sorting. That is, all changes are exported even if you have filtered them from the editor. Sort order is not maintained in the export file.
  • Synchronization or merging is not affected by filtering. That is, delta DDL is generated for all objects, regardless of whether they are filtered from the editor view.

This feature is available only when you compare data objects.

Procedure

To filter and sort differences in the Compare editor:

  1. In the Compare editor, click Filter Configuration Filter Configuration toolbar button icon from the Compare editor toolbar.
  2. If you do not want to include certain objects in the comparison, select filtering options. For example, you can select to filter primary keys out of the comparison.
  3. If you want to sort the changes, select sorting options. For example, you can select to sort the differences in the Compare editor in ascending or descending order.

Results

The differences between the data objects that are shown in the Compare editor are filtered or sorted based on the selections that you made.

Feedback