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

The options depend on the selected Output Format. 

For the SQL and XML formats, you can choose to export the DDL, DDL for the indexes, and the table data: as INSERT statements for the SQL statement or in one of three XML formats.

For the XLS format, you can choose export the data as either regular Binary Excel or OOXML for Excel 2007 and later. 

Most formats also let you specify other options, such as delimiters, title and descriptions. Just select an Output Format to see which options are available.

You can also adjust the Data Formats specifically for the exported data. By default, the formats defined in Tool Properties are used, but sometimes you need to export dates and numbers in a different format because you intend to import the data into a different type of database.

In the Data Format Settings dialog you can also specify how to quote text data and how to handle quotes within the text value.

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 for the data files. If you do not specify a directory, the operating system's default directory for temporary files (e.g. C:\TEMP or /tmp) is used.

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