Frequently Asked Questions

Both tools, Exportizer Enterprise and Database Tour (Pro), although differ in the interface, use the same export engine and have almost the same export possibilities. But Database Tour has many other database related features, while Exportizer Enterprise is designed for export purposes mainly.

Exportizer is a light-weight tool. Its user interface parts work a bit faster than in Database Tour.

Here is a brief comparison of the main features:

Feature	EE	DT	DTP
Exporting from GUI
Exporting from command line
Other command line operations
Database reports
Querying data by SQL
Executing any SQL queries
Executing multi-statement SQL scripts
Transaction support	only on target side
Other database related capabilities like searching and replacing text, creating tables in GUI, editing BLOB data etc

Both database reporting tools, Database Tour Pro and Reportizer , use the same report engine. The report templates of them are usually compatible and can be opened/edited by both applications.

But there are also important differences between these tools. Database Tour Pro is a general database tool, where db reporting is one of the many features, while Reportizer is designed for reporting purposes only. Each of them has its own advantages, but Reportizer in most cases provides more powerful and convenient way to design database reports, which achieved by including the following features:

Opportunity to work with report collections (report repositories). Report repositories are either folders with report files or database tables where reports are stored in BLOB or CLOB columns. Reportizer shows reports from open repository in a sorted list with descriptions.
Ability to disable report editing by the application administrator (with password protection), which is necessary sometimes when the software is used by several people and some of them are not advanced users and have permissions only to print or export reports, but not to edit them.
Ability to edit reports not only in visual designer, but also in text mode.

Please see documentation .

Please see documentation .

Note, that you may use your purchased product on the amount of computers, which is allowed by purchased license.

For example, if you purchased one license, you may use the application on one computer only, as it is described on the order page.

In your case, it means you have already activated Database Tour with your activation key on other computer(s) and you are trying to activate it on extra computer. So, you should uninstall Database Tour on some other computer(s) and try again. If the problem still exists, please contact us with specifying your order number.

The activation of Database Tour is done in two steps: validation of your activation key, and the activation itself.

You usually should not have problems with first step, if you have valid activation key.

The second step (activation) is used to prevent casual piracy. Note, that you may use your purchased product on the amount of computers, which is allowed by purchased license. Activation just ensures that your serial number was used in compliance with Database Tour license; in other words, it ensures, that amount of computers, where your activation key is used, is not larger than amount of copies purchased.

For example, if you purchased one license, you may use the application on one computer only, as it is described in the order page.

Activation is usually done automatically behind the scene, after you enter your activation key and if you have Internet connection.

In your case, it seems, the serial number validation passed successfully, but activation failed due to either your activation key is used on other computer(s), or you have not Internet connection on your computer.

If you have not Internet connection on the computer where you want to use Database Tour, you should obtain the activation code using another computer, which has Internet connection, and then enter it in the application; just follow instructions, which appear after unsuccessful activation.

By default, the tables are opened in a read-only mode. To turn on the read-write mode, just click the corresponding button above the table. In order to set the read-write mode as default mode for tables, choose Options | Environment | Database and turn on the Allow edit tables after opening option.

In order to have the SQL queries editable, choose Options | Environment | Database and turn on the Use editable queries, if possible option. Please note that some queries cannot be editable (for example, if they use more than one db table etc).

Database Tour executes SQL queries by passing them to the database engine or server used when opening the database. So please refer to the corresponding database engine or server documentation.

Here are some examples:

You are working with an Oracle database: read the Oracle documentation;
You are working with a SQL Server database: read the SQL Server documentation;
You are working with a PostgreSQL database: read the PostgreSQL documentation;
You are working with dBase (dbf) files via BDE: read BDE Local SQL documentation;
You are working with a MS Access (mdb) database via Microsoft Jet engine: read the Microsoft Jet documentation

and so on.

See also
Working with SQL Queries

Database Tour allows simultaneous running SQL queries from different SQL windows if the Asynchronous query execution option is set (Options | Environment | Database). This option is turned on by default. It is recommended to use FD interface to connect the database.

But make sure that your database supports multi-threading too. Most of server databases like Oracle, PostgreSQL, SQL Server etc support it. SQLite has limited support for it. To be sure, read the documentation of your database.

You have two ways to do this:

• Select needed database object and switch to Script tab. Basic SQL script is generated here.
• Select needed database object in the list of objects, right-click it and then choose Generate SQL | DDL | Create DDL Script.... Choose desired options and click OK. Here, you get the most complete script, sometimes along with related objects and database permissions (please see notes below). Moreover, if you switch to Multiple Selection mode for the object list, you can produce the DDL script for all selected objects.

Notes
The completeness and correctness of the generated DDL code may differ for different database types and different database objects. The most complete code is created for Oracle, PostgreSQL, Interbase, and Firebird databases, especially for such db objects like tables, views, procedures, sequences, and users. We are continuously working for further extending this functionality.

Please see advices from the documentation .

It can be a challenge to export large tables or queries from one database to another. Sometimes, you may get an Out of memory error during the export process or even when opening such a table.

You should try non-standard approaches. See more in Database Tour documentation .

Yes. You can do this by several ways.

• If your database allows such formulas in SQL, use this way. For example:

  SELECT
    column1,
    column2,
    column3,
    column1 + column2 AS MyFormula1,
    column2 || column3 AS MyFormula2
  FROM MyTable

• Some databases like Interbase, Firebird, latest versions of Oracle, SQL Server, PostgreSQL etc. allows to use computed columns in database tables. This is a very efficient way to get your data calculated. Database Tour can create such columns during on-the-fly table creation when exporting data to such databases (you should specify such column types at the Field Mappings step).

• Another way is to specify your formulas at Field Mappings step of Export dialog. In formulas here, you can use columns of your source table, special functions, and even local files.

  So, click Add button. A new row will appear for a new field mapping. Click '...' button in the first column of the field mappings table and specify your expression (formula). Examples:

  1. Get sum of two columns

  vle_expr(dataset_field_val(1, 'column1') + dataset_field_val(1, 'column2'))

  2. Replace specific characters in the column's data

  vle_expr(string_replace(dataset_field_val(1, 'column3'), char(0), ' '))

  3. Get the size of a file, referred in the column's data

  vle_expr(file_size(dataset_field_val(1, 'column3')))

  In the next column of the mappings table, specify the target field name as you usually do for exporting physical fields.

Please also read the detailed guidance from our Exportizer documentation which can be easily applied in Database Tour too.

If you export data to another database field of type BYTES, then everything is quite simple. All you have to do is to match the source and target fields in Field Mappings step of Export dialog.

If you export data to some of file formats, e.g. Excel or HTML, the result will be in a hexadecimal format string, which will start with 0x.

If you export data to database fields of CHAR or CLOB (i.e. text compatible) types, a bit more work is needed. In Field Mappings step of Export dialog, match the source and target fields, then specify the following expression instead of the source field name:

vle_expr(dataset_field_hex_val(1, 'YOUR_SOURCE_FIELD_NAME'))

As a result, the data will be exported to the destination as a hexadecimal format string, which starts with 0x.

And you can export data from the hexadecimal format string to BYTES field too. Just make sure your source string starts with 0x: this will indicate that the source data is the sequence of bytes in a hexadecimal form.

Open the source database. Go to the table list and right-click it. Choose Multiple Selection. Then select needed tables in the list and click Export button. Choose the target format and export options, then proceed to Table Mappings step and specify how the source tables will match the destination tables or files.

Please read the detailed guidance from our Exportizer documentation which can be easily applied in Database Tour too.

You can export the content of any column to an individual file. The process is described in details in our Exportizer documentation . These things work in Database Tour too.

Yes. Database Tour Pro can perform database operations from command line with optional use of /silent switch.

See also
Brief info and examples: Command Line Using.
Full technical documentation about command line.

In Database Tour, you can manage transactions (if your database supports them).

You can either work in Autocommit mode or use explicit transactions. Choose Options | Environment... | Database to manage Autocommit settings.

For server databases, each Table or SQL window can be associated with a separate transaction.

See more in the documentation

Choose Database | Registered Databases....

At the top, you will see the path to the file with stored database settings. You can either copy that file from Windows Explorer or export the settings to a new file using the corresponding button to the right. Then place the file on destination computer and import it to Database Tour from Database | Registered Databases... interface.

Yes. When this library exists in the folder, where BDE (Borland Database Engine) files are located, the corresponding items will appear in Database Tour 32-bit Table | BDE utilities menu.

Attention! BDE is an obsolete technology. You use this feature at your own risk.

First, make sure you use Database Tour 32-bit. BDE is 32-bit and it cannot be accessed from 64-bit applications.

Then check whether the BDE correctly installed:

• Find the BDE location. Go to Windows registry and open HKLM\SOFTWARE\Borland\Database Engine key (if your OS is 32-bit) or HKLM\SOFTWARE\WOW6432Node\Borland\Database Engine key (if your OS is 64-bit), and read the DLLPath parameter.
• Go to that folder and find idapi32.dll file there.
• Check the version of the library. It must be 5.0 or higher.

If any of the steps above fails, then BDE is not properly installed.