Export mode is one of the most important export options. In every export format description, all available export modes are listed. Below, they are all collected, with additional details.

The export modes can work differently depending on export format. The most significant changes are between exporting to file formats and exporting to databases.

Export Modes for Exporting to File Formats

REPLACE+INSERT

The target file is created and filled with incoming rows; if the target file already exists, it is overwritten.

CREATE_OR_REPLACE

A blank target file (using appropriate structure) is created; if the target file already exists, it is overwritten.

For most of the formats, it will produce the blank file with column headers (if any). But for some formats, it could be more complex result; for example, for Text/CSV, if the Schema option is not Standard, complete schema will be also created.

APPEND

The target file is appended with incoming rows; if the target file does not exist, it is created. Available only in Exportizer Pro and Exportizer Enterprise.

This mode is supported for several formats only:

Text/CSV The schema, field structure and most of the export options like Encoding must be compatible with existing target.
JSON The field structure and most of the export options must be compatible with existing target.
HTML The field structure and most of the export options must be compatible with existing target. But for some case, more complex rules are applied; read the format description for details.
XML The field structure must be compatible with existing target.
SQL Script The field structure and most of the export options must be compatible with existing target.

Export Modes for Exporting to Databases

Exporting to databases is available only in Exportizer Enterprise and Exportizer Pro; the latter one can export only to ODBC data sources. Use Database export format for that.

REPLACE+INSERT

The target table is created and filled with incoming rows; if the target table already exists, it is overwritten.

CREATE_OR_REPLACE

A blank target table (using appropriate structure) is created; if the target table already exists, it is overwritten.

APPEND

The target table is appended with incoming rows; if the target table does not exist, it is created.

The field structure of the source must be compatible with existing target structure.

EMPTY+INSERT

The target table is emptied before inserting incoming rows; if the target table does not exist, it is created.

The field structure of the source must be compatible with existing target structure.

UPDATE

The records in the target table that match incoming records, are updated with incoming records. Key fields must be defined to match the records.

Notes

APPEND+UPDATE

The records in the target table that match incoming records, are replaced with incoming records. Unmatched incoming records are appended (inserted) to the target table. This mode is a good starting point when you want to keep your target table synchronized with the source data. Key fields must be defined to match the records.

Notes

DELETE

The records in the target table that match incoming records, are deleted. Key fields must be defined to match the records.

Notes

Using Export Mode in Multi-Table Exporting

When exporting or importing multiple datasets, you can specify the common export mode common for all datasets. But this value can be overridden later for each individual dataset-to-table pair in Table Mappings section when editing Transformation subsection for chosen pair:

Table transformation during multi-dataset importing

Using Export Mode in Command Line

In the command line or action files, use the /ExportMode parameter to specify the export mode. For example:

See also