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

To export a table:

  1. Select the 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.

Output Format

You can export tables in one of these formats: CSV, HTML, SQL, XML, XLS (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\hans\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\hans\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 care 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.

Saving And Loading Settings

Other Ways to Export Table Data