|Database Tour Documentation|
How to Start
Database Tour can work with databases via several database engines. Some database types can be opened only by one of these engines (for example, UDL files can be opened only by ADO). But some database types can be opened by more than one engine (for example, Paradox (DB) and dBase (DBF) files can be opened either by ADO or BDE). If more than one engine is available, then you can switch between them when opening databases.
Database Tour works with following database types:
- Folders with files of the local databases (for example, of Paradox (DB), dBase (DBF), comma separated values (CSV) formats).
- Files of multi-table databases (for example, Microsoft Access databases (MDB) or Microsoft Excel worksheets (XLS)).
- Local or remote databases, for which BDE aliases, ODBC data source names (DSN) or ADO connection string are defined.
Preparing data sources
In many cases it is recommended to define ODBC data sources (or BDE aliases, if you prefer to work through BDE) for your databases. Working with such named data sources usually is more convenient than working directly with database files or folders because of shorter name, customizable database connect.
To create or modify an ODBC data source, use the corresponding program from Windows Control Panel.
To create or modify a BDE alias, you can use BDE Administrator utility from Windows Control Panel (if any) or choose the BDE Aliases module in Database Tour.
Working with existing databases
In Database Tour, you can work with already existing databases, which was created in Database Tour or other programs. Please follow Opening Data Source topic to learn how to open different types of databases. Once the data source is opened, you can start to read or change data from the database tables, perform SQL queries or use many other useful functions available in Database Tour.
Creating new databases
Database Tour allows creating local databases, where database is a physical directory (folder), and the files in it are the tables (for example, dBase or Lotus databases). Databases of other types (e.g. Oracle, Interbase, SQL Server, Microsoft Access, etc.) still can be opened in Database Tour, and new tables in such databases can be created, but current version does not support creating the databases of these types, you should do this in other tools.
To create local (folder based) database, you need to open the folder, which you wish to use as the database.
Creating new tables in the databases
New tables can also be created by exporting data from any open database to another database using Database Tour export tool.