Skip to end of metadata
Go to start of metadata

The Options section contains options common to all Output Formats at the top, followed by options for the selected format.

Example of the options for SQL:

Example of the options for Excel:

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

For the Excel format, you can choose to export table data as either in the XLSX (default) or the legacy XLS format. 

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. All options are described in the context of the @export command, as the Export dialog is just a GUI for the command.

You can adjust the Data Formats specifically for the exported table 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.

If you are exporting table data in the SQL format from one database type (e.g. Oracle) to import it in a database of a different type (e.g. PostgreSQL) by executing the generated script, you need to be aware of differences in the literal formats for Date, Time and Timestamp data. If you connect to the other database using a JDBC client like DbVisualizer, you can select the JDBC escape format for these data format. This generates literals that the JDBC driver converts into a format the target database can interpret.

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

  • No labels