How To: Connect to a Database

       Create a New Server Connection

To create a server connection, perform the following actions:

1.On the Start Page click New Schema Comparison. The New Schema Comparison wizard opens.

2.Click New to create source and target connections.

3.The Database Connection Properties window will open.

Direct Connection

If you want to connect to the server using the Direct mode, follow the steps below:

1.Click the Direct check box.

2.Enter the host name in the Host box.

3.Enter the port information in the Port box. Default port number is 1521.

4.In the Service Name box enter the database name to which you want to connect to.

5.Enter the login credentials in the User and Password boxes.

6.(optional) You can specify how to connect to the server in the Connect as box. 'Normal' is set by default. Alternatively, you can connect to SYSDBA and SYSOPER administrative privileges selecting 'SYSDBA' or 'SYSOPER' options.

7.Enter a distinctive name for your new connection in the Enter connection name box. Alternatively, the connection name is generated automatically as [user]@[host]:[service name].

8.(optional) You can click Advanced to configure advanced connection properties.

9. (optional) You can click Test Connection to verify that you can connect to the database by using the specified connection information.

10. Click OK to create the connection.

Connection via the OCI

If you want to connect to the server via the OCI, follow the steps below:

1.Enter the database name in the Server box.

2.Enter the login credentials in the User and Password boxes.

3.(optional) You can specify how to connect to the server in the Connect as box. 'Normal' is set by default. Alternatively, you can connect to SYSDBA and SYSOPER administrative privileges selecting 'SYSDBA' or 'SYSOPER' options.

4. If you have several Oracle clients installed, in the Home box select which home you want to work with for the connection. If an Oracle client is unique, it is selected by default. If you want to connect to the server via an Instant client, specify the client in the Home box as well.

Note

If you cannot find the server you want in the server list, your Oracle client is not properly installed.

5.Enter a distinctive name for your new connection in the Enter connection name box. Alternatively, the connection name is generated automatically as [user]@[server].

6.(optional) You can click Advanced to configure advanced connection properties.

7. (optional) You can click Test Connection to verify that you can connect to the database by using the specified connection information.

8. Click OK to create the connection.

Alternative ways to access the Database Connection Properties window:

1.In the Database menu, click .

2.Click the New Connection button on the Connection toolbar.

Note

The Connection toolbar is hidden by default. To unhide it, right-click on the menu bar and click Connection.

       Edit and delete connections

You can create, edit, and delete connections with the help of Connection Manager. To open it, click Edit on the Source and Target page of the New Schema Comparison wizard or click the Connection Manager button on the Database menu.

To edit a connection, select it in the Connections list and click the Edit button or just double-click it in the list. The Database Connection Properties window will open.

To delete a connection, select it in the Connections list and click the Delete button or press the DELETE key.

You also can use the New button to create new connections.

       See Also