Schema Compare Source and Target Dialog

In the Schema Compare Source and Target Dialog, you can select the source and target database connections or Oracle Database Project version 2 projects for a schema comparison. This dialog also allows you to filter results. When you press OK, the Schema Compare Results Window opens to display the results.

See Also:

Opening the Schema Compare Source and Target Dialog

You can open the Schema Compare Source and Target Dialog from the Visual Studio Tools menu - Oracle Schema Compare menu item, the context menu for Data Connection nodes described in Menu Options, or the Oracle Database Project Version 2 context menu.

Using Schema Compare Source and Target Dialog

The Schema Compare Source and Target Dialog looks similar to this:

Description of sc_main_basicnew.gif follows
Description of the illustration sc_main_basicnew.gif

The controls in the basic Schema Compare Source and Target Dialog are as follows:

Control Description

Source Database Connection/Project radio button

Selects whether the Source is a Visual Studio Server Explorer Oracle Database connections or an existing Oracle Database Project Version 2 project.

Target Database Connection/Project radio button

Selects whether the Target is a Visual Studio Server Explorer Oracle Database connections or an existing Oracle Database Project Version 2 project.

Source Database Connection

Select a source from the existing Visual Studio Server Explorer Oracle Database connections for the schema comparison.

Target Database Connection

Select a target from the existing Visual Studio Server Explorer Oracle Database connections for the schema comparison.

Source Database Project

Select a source from an existing Oracle Database Project Version 2 project for the schema comparison.

Target Database Project

Select a target from an existing Oracle Database Project Version 2 project for the schema comparison.

New Connection

Create a new Oracle Database connection to serve as the source or target for the schema comparison by opening the Connection Dialog Box.

OK

Launches the Schema Compare Results Window to display the results of the schema comparison.

Cancel

Closes the dialog without performing a schema comparison.

Advanced

Provides two additional tabs for filtering the results of the schema comparison: Schema Compare Object Types and Schema Compare Filters.

Schema Compare Object Types

Description of sc_main_advanced_objectsnew.gif follows
Description of the illustration sc_main_advanced_objectsnew.gif

Schema Compare Filters

Description of sc_main_advanced_filtersnew.gif follows
Description of the illustration sc_main_advanced_filtersnew.gif

Schema Compare General Options

Description of sc_main_advanced_general.gif follows
Description of the illustration sc_main_advanced_general.gif

The additional controls for Object types and Filters in the advanced Schema Compare Source and Target Dialog are as follows:

Control Description

Object Types tab

Select the schema object types to compare. Default values can be set in the Options for Schema Compare Object Types.

Filters tab

Select the results types you wish to see. Default values can be set in the Options for Schema Compare Filters.

(General Tab) Drop objects in target that are not in source

Drops objects in target that are not in the source.

Select All

Selects all options in the tab.

Clear All

Deselects all options in the tab (except for one).

Basic button

This button closes the Advanced pane.