Here, the interfaces (GUI and non-GUI) of opening databases are described. Alternatively, you can view about how to open databases depending on their type.

Database Tour Interfaces to Open Databases

Using Open Data Source dialog

Use Open Data Source button  or the corresponding item from the Database menu. In this dialog, you choose all parameters you need to open the database, and register the database under a friendly name for further use.

Opening Data Source

Example of configuring an Oracle database connection using FD interface:

Vendor homepathC:\app\product\12.1.0\client_1
Databasemain_db
OS authenticationNo
Authentication modeNormal
CharsetWE8MSWIN1252
Application nameDatabase Tour Pro
User namedexter
Password********
SQL command separator<sqlplus>

Opening files directly from Windows Explorer

Some files (for example, DB, DBF, MDB etc.) can be opened by using file associations. If such a file is associated with Database Tour, then clicking it twice causes the Database Tour to start and open the selected file.

Also, you can drag files from Windows Explorer and drop them into the open instance of Database Tour.

Opening databases from command line

Almost all supported database types can be opened from the command line.

Opening files, which are not database files

Besides databases, Database Tour can also open some other file types:

When opening files of other types, Database Tour in most cases will try to open them like it does for database files (see above).

Reopening previously opened databases

The most recently used (MRU) databases can be accessed from Database | Reopen or Database | Registered Databases... menu, and can be easily reopened from there. Opened databases from this list are marked with checkboxes.

Some databases require password to be open. You can optionally save the password after successful database opening to avoid typing the password in the future. All saved passwords can be removed by choosing Database | Clear Password List.

After a database is opened, the list of its tables is available in the Tables pane of Object Browser, which occupies left part of the main window. You may open a table from the opened database by the following ways:

In addition to tables, you may open such data sets as SQL queries.

See also

 Closing Data Source

 Ways of Opening Diferent Data Source Types

 Error Messages

 Command Line Usage