Export Directives File Description

The export can send out a single table, several tables, or all objects in the database. Unlike the purge and archive functions, it is not possible to export a subset of objects with complex SQL. No objects are deleted from the database in this process. The objects are exported into a data file which is defined with the –export command parameter, and they are sent in a format that both ArchiveManager and Dataex can read.

Export directives files cannot be created with the –generate command and do not require a checksum.

The export directives file only specifies which objects to export and/or not export:

EXPORT OBJECT <object type> [,<object type>]….;

And/Or

NO_EXPORT OBJECT <object type> [,<object type>]….;

The EXPORT OBJECT directive will export the specified object types. For example, only the rule objects will be exported with the following directive:

EXPORT OBJECT rule;

The NO_EXPORT OBJECT directive is only needed with the "EXPORT OBJECT ALL;" directive. In the next example, all table objects are exported (ALL), except for site_part, gbst_lst, and gbst_elm:

EXPORT OBJECT ALL;

NO_EXPORT OBJECT site_part, gbst_lst, gbst_elm;

See Also

Export Directives Files

Export Directives Elements

Next

Export Directives Elements
Export Directives File Description