Managing Database Connections

dbForge Studio for Oracle offers you a visual, quick, and simple way to manage database connections through the Database Explorer window.

By default, Database Explorer displays recently used database connections. If you open the Database Explorer for the first time, no connections are shown.

In Database Explorer, you can:

  • create a database connection
  • set coloring to a connection category
  • open and close a database connection
  • view, edit, duplicate or delete a database connection

Creating a database connection

  1. Open the Database Connection Properties dialog box by either of these ways:
    • Click the New connection icon New Connection icon in Database Explorer
    • Right-click in Database Explorer and select New Connection on the shortcut menu
    • On the Database menu, click New Connection

    Database connection properties window

  2. Configure connection parameters. The newly-created connection marked with the Connection icon icon appears in Database Explorer.

Windows connection coloring

Windows connection coloring allows you to immediately know which server you are connected to. You can add coloring for each server connection.

Connection coloring

Opening a database connection

In Database Explorer, double-click a connection. The connection icon is set to and database objects are shown.

Closing a database connection

In Database Explorer, right-click a connection and select Close. The connection icon will be changed to .

Viewing database connection information

In Database Explorer, right-click a connection and select Properties. The Properties window opens displaying the connection properties.

Database connection properties window

Editing a database connection

Right-click a connection in Database Explorer and select Modify Connection. The Database Connection Properties dialog box opens enabling you to edit the parameters.

Duplicating a database connection

Right-click a connection in Database Explorer and select Duplicate Connection. A copy of the connection will appear in the Database Explorer window.

Deleting a database connection

Right-click a connection in Database Explorer and select Delete. The message appears asking Are you sure you want to remove database connection *name?*:

  • Click Yes to drop the connection.
  • Click No to cancel dropping.