You can export an individual table using the Export Table assistant.

To export a table:

  1. Select a table node in the Databases tab tree,
  2. Open the Export Table dialog from the right-click menu,
  3. Select an Output Format, Output Destination, and Options,
  4. Click Export.

Below is an example of what the Export Table window looks like. There may be different options based on what database type the table is exported from.

Output Format

You can export tables in one of these formats: CSV, HTML, SQL, XML, Excel, or JSON.

For the SQL and XML formats, you can choose to export the DDL and the table data; the other formats only export table data.

You can control whether to use delimited identifiers and/or qualified names by default in the DDL and INSERT statements generated for the SQL format, and you can override the defaults in the Export dialog for a single export operation.

Output Destination

The destination can be one of:

Options

Using Variables in Fields

Exporting Binary/BLOB and CLOB Data

You can use the export assistant to export Binary/BLOB and CLOB data. You enable this by choosing File as the data format for Binary/BLOB and/or CLOB data. Optionally, you can specify the directory or filename pattern for the data files. If you do not specify a directory or filename pattern, the operating system's default directory for temporary files (e.g. C:\TEMP or /tmp) is used.

A pattern is a path with fixed and variable parts, where the variable parts are expressed as DbVisualizer variables, e.g. C:\Users\wti\exp\${dbvis-date}$\${COUNTRY_NAME}$.txt. You can select variables to insert at the current caret position in the path field from the dropdown. The variables that can be used are the predefined DbVisualizer variables plus variables for each column in the table, e.g. ${COUNTRY_NAME}$ in the example above. Another special variable that can be helpful here is ${dbvis-column-name}$. If a table has multiple BLOB or CLOB columns, you can use it in the pattern to export the columns to separate files, e.g. C:\Users\wti\exp\${dbvis-column-name}$.txt. All variables that can be used are listed in the menu that is displayed when you click the blue arrow to the right of the field. You can select a variable from the menu to insert it in the pattern field at the caret position.

The data for each individual value of this type is then exported to a separate file and a DbVisualizer variable referencing the file is inserted in the main export file.

Example:

Assume you have a table with multiple pictures and want them exported in individual files, for instance a BOOK table with the columns ISBN and pictures of FRONT and BACK:

ISBN       FRONT               BACK 
---------- ------------------- -------------------
0345391802 BINARY, 4,998 Bytes BINARY, 4,998 Bytes
0345391810 BINARY, 4,998 Bytes BINARY, 4,998 Bytes

If you specify the output as D:\tmp\${ISBN}$-${dbvis-column-name}$.png, you will get the following image files:

Saving And Loading Settings

Other Ways to Export Table Data