9.1 Overview

Executor: User with DBA privilege

The dictionary import/export utility migrates table definition information, trigger definition information, and stored procedure information between HiRDB systems.

This utility outputs table definition information, trigger definition information, or stored procedure information to an export file and migrates the information by using the export file as the input file to another HiRDB system. Output of table definition information, trigger definition information, or stored procedure information to an export file is called exporting; input of the contents of an export file to a HiRDB system is called importing. This utility can also generate a definition SQL on the basis of the definition information in export files.

Figure 9-1 provides an overview of the dictionary import/export utility (pdexp) (importing and exporting table definition information, trigger definition information, or stored procedure information), and Figure 9-2 provides an overview of generating a definition SQL.

You import or export table definition information, trigger definition information, or stored procedure information in the following cases:

You generate a definition SQL in the following case:

Organization of this section
9.1.1 Table definition information import/export
9.1.2 Trigger definition information import/export
9.1.3 Stored procedure information import/export
9.1.4 Generation of a definition SQL