Schema Compare for Oracle 6

Setting data sources

When you create a new project, Schema Compare for Oracle requires information about which data sources to compare and how to connect to them.

This page describes how to connect to data sources in Schema Compare for Oracle.

Selecting data sources

You enter information about the data sources you want to compare on the Project Configuration dialog box:

Specify the two data sources you want to compare in the Data Sources tab. You specify a source and a target. The source is the data source that will not change. The target is the data source that will change after you deploy.

You can compare any combination of data source types.

To switch the source and target, click  

You can compare the following types of data source:

  • Database
    A database on an Oracle server that you can connect to. You need to enter connection details. You can connect to an Oracle database using a TNS connection or a manual connection.
  • Snapshot
    A file created by Schema Compare for Oracle that contains information about the structure of database schemas.
  • Scripts folder
    A folder containing SQL scripts that represent the schema.

Using a TNS connection

With a TNS connection, you can connect to databases using an alias specified in your tnsnames.ora configuration file. By default, tnsnames.ora is located in: ORACLE_HOME/network/admin

To connect using a TNS connection:

  1. Under Source or Target, select Database.
  2. Select the TNS Connection tab, if it is not already selected.
  3. In the Oracle home box, type or select the name of the Oracle home.An Oracle home is the location of an Oracle Database installation.
  4. Under Database, in the Network Alias box, type or select the alias (network service name) of the database and then enter the User name and Password.If you want Schema Compare for Oracle to remember your password, select the Save check box.
  5. In the Connect as box, select the privileges you want to connect with.

Using a manual connection

A manual connection is useful if:

  • you do don't have Oracle client software installed, and can't use a tnsnames.ora file
  • you do don't have an alias entry for a database you want to compare in your tnsnames.ora file
  • you're having problems connecting to a database using a TNS connection
  • you want to connect to a database without an Oracle client installed using a direct connection

To connect using a manual connection:

  1. Under Source or Target, select Database as the data source.
  2. Select the Manual Connection tab.
  3. In the Host name box, type the host system name for the database .A host system name can be:
    • an IP address
    • a computer name
    • localhost, if you connect to a database that is on the same computer as Schema Compare for Oracle
  4. In the Port box, type the listener port number.
  5. From the Database menu, select SID or Service name.A SID (system identifier) is a unique name for an Oracle database on a specific host; a service name is an alias for a database specified in your tnsnames.ora configuration file.
  6. Type the SID or service name as appropriate, and enter the User Name and Password.If you want Schema Compare for Oracle to remember your password, select the Save check box.
  7. In the Connect as box, select the privileges you want to connect with.

Selecting a snapshot

  1. Under Source or Target, select Snapshot.
  2. In the Snapshot box, type the file path of a saved snapshot file or click to browse to a snapshot file.

Schema Compare for Oracle displays information about the database from which the snapshot was created.

For information on creating and saving snapshots, see Using snapshots.

Selecting schemas to compare

When you have specified source and target data sources, you can select the schemas to compare. You can compare a single schema from each data source, or multiple schemas.

To compare a single schema from each data source:

  1. Under Source, in the Schemas box, type or select a schema.If a schema with the same name exists in the target data source, it is automatically selected.
  2. If you want to compare to a different schema, under Target, select the required schema.

If no schemas are displayed in Schemas, click Refresh list.

If you're using a snapshot, you can only select from the schemas that were included when the snapshot was created.

To compare multiple schemas from each data source:

  1. In the Schemas boxes, select a source and a target schema to compare.
  2. Click + Add schemas to the comparison.

    The schemas you selected are added to the comparison, and displayed in the lower pane:

  3. Repeat this process for as many schemas as you want to compare.
The schemas selected in the Schemas boxes and the schemas in the lower pane are all compared when you run the comparison.

If you want to remove schemas that you have added to the comparison, click x Remove.

Using a direct connection

You can choose to connect to a database directly over TCP/IP when using a manual connection.

A direct connection doesn't require an Oracle client, and can be useful if you're having problems connecting to databases.

To use a direct connection:

  1. On the Tools menu, click Application Options.
  2. Under Connections, select the Use direct connection check box.
  3. Click OK.

You can now use a manual connection to connect to a database directly.

If you use a direct connection, you can't use a service name to connect to a database.

Didn't find what you were looking for?