Chat now with support
Chat with Support

Toad for Oracle 13.1.1 - Getting Started Guide

Welcome to Toad Toad Resources Required Privileges Create and Manage Database Connections Editor Basics Schema Browser Basics Data Grid Basics Work with Data Work with Database Objects Work with Code
Write Statements and Scripts Work with the Query Builder Execute Statements and Scripts Save Statements (SQL Recall) Work with PL/SQL Objects Debug Analyze Code Optimize SQL
Customize your Toad Environment Use Other Quest Software Products with Toad

Import/Export Connection Settings

Create and Manage Database Connections > Import/Export Connection Settings

You can export and import Toad connection settings. This feature is especially helpful when you need to work with Toad on a different computer or share the settings with another person. If you save your connection password, it is encrypted in the exported file.

  • You can export to XML format.
  • You can import from XML or INI format.

To export connection settings

  1. Click on the standard toolbar to open the Database Login window.

    You can also select Session | New Connection.

  2. Click on the toolbar.
  3. Enter a file name in the File Name field and click Save.

To import connection settings

  1. Click on the toolbar.
  2. Select the file and the file type, then click Open.

To import from LDAP

  • In the Database Browser, click the folder icon.
  • Select Add databases to tree.

The Database Browser displays columns for Server, Database, Comments, and Last Connected.

 

Automatically Connect on Startup

Create and Manage Database Connections > Automatically Connect on Startup

Rather than have to manually connect to one or more databases every time you start Toad, you can configure Toad to start selected (or all) connections automatically when you start Toad.

To automatically open connections

  1. Click on the standard toolbar to open the Database Login window.

    You can also select Session | New Connection.

  2. In the connections grid, select the checkbox in the Auto Connect column.

 

Use Previous Connections

  • Click in the standard toolbar to open the Database Login window, and then double-click the previous connection from the grid.
  • Click the arrow beside in the standard toolbar, and then select a connection from the list.

Change Active Connection in Window

Create and Manage Database Connections > Change Active Connection in Window

You can easily change the connection in an open window to a connection you currently have open or a connection that you have recently used.

To change the active connection in a window

Click the arrow beside in the window toolbar and select an open or recent connection from the drop-down.

 

Related Documents