Setting data sources

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

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

Selecting data sources
Using a TNS connection
Using a manual connection
Selecting a snapshot
Selecting schemas to compare
Using a direct connection

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.

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 will 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.

  If you select a snapshot as the target, the snapshot file will not be modified. Instead, a synchronization script is generated to modify the database from which the snapshot was made.

  You can compare any combination of data source types in your project.

Using a TNS connection

A TNS connection enables you to connect to a database 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.

Using a manual connection

A manual connection can be useful if:

• you do not not have Oracle client software installed, and cannot use a tnsnames.ora file
• you do not have an alias entry for a database you want to compare in your tnsnames.ora file
• you are experiencing 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.

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 Working with 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.

Note that if you are 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.

Note that 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 you are using a manual connection.

A direct connection does not require an Oracle client, and can be useful if you are experiencing 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.

Note that if you use a direct connection, you cannot use a service name to connect to a database.