Schema Compare for Oracle - 1.0

Schema Compare for Oracle

Learning Schema Compare for Oracle - 1.0

Viewing the comparison results

When you have compared the data sources, Schema Compare for Oracle displays the comparison results. The Results pane displays all the objects you can select for synchronization:

You can define which objects are displayed by setting up a filter. You can also view the differences in the objects' creation scripts in the SQL Differences pane:

To compare the data sources again using the same project configuration, and update the comparison results, click Refresh.

Object groups

Objects in the results are displayed in groups. You can select how objects are grouped using the Group By box:

You can group objects by:

  • Type of difference

    In the Results pane, when objects are grouped by Type of difference, the Type column indicates the difference:

    objects that exist in both data sources but are different

    objects that exist only in the Source

    objects that exist only in the Target

    objects that exist in both data sources and are identical

    Type of difference is the default grouping.

  • Type of object

    In the Results pane, when objects are grouped by Type of object, the Type column indicates the type of object:

    Tables

    Views

    Procedures

    Functions

    Indexes

    Types

    Triggers

    Synonyms

    Sequences

    Packages

    The Owner column displays the owner, or schema, of the object.

    Note that this column is shown only when more than one schema in the database is compared.

  • No groups

    All objects are listed individually; they are not displayed in groups.

To view the individual objects within a group, click , or click the group heading bar:

Using the filter

You can specify which objects are included in, or excluded from, the results, by using the Filter pane.

To display the Filter pane, click Filter Setup:

The default filter is All objects included, which includes all objects in the Results pane.

To exclude an object type from the results, clear its check box. If you only want one type of object to be displayed in the results, first clear the All object types included check box, and then select the check box for that object type.

Note that if you select an object for synchronization and then set up a filter that excludes that object type, the object is not included in the synchronization. Only selected objects that are shown in the comparison results are included.

For example, if you select TableA for synchronization, and then set up a filter to exclude all tables, no tables are shown. If you subsequently remove the filter, TableA is displayed and remains selected for synchronization.

Finding an object

You can also use the Find box to assist you with your selection.

To locate objects, in the Find box, type the search text. To select a recent search, click the Find arrow button

As you type, objects are grouped in the upper pane by whether they match or do not match what you type.

Schema Compare for Oracle searches object names and owners (schemas).

Note that the search is not case-sensitive.

To clear the Find box, click the button.

Note that if an object matches the term in the Find box, and is excluded by a filter, it is not displayed in the results.

See also

Setting up the synchronization

Viewing the SQL differences

Was this article helpful?

Search support
Forums
Visit the Schema Compare for Oracle forum.
Learning Schema Compare for Oracle
Knowledge base

Schema Compare for Oracle

all SQL products

all products

Notes & articles

Schema Compare for Oracle

all SQL products

all products

Demos & walkthroughs

Schema Compare for Oracle