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 Overview of dictionary import/export utility (pdexp) (importing and exporting table definition information, trigger definition information, or stored procedure information) 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 Overview of dictionary import/export utility (pdexp) (generating a definition SQL) 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:
Figure 9-1 Overview of dictionary import/export utility (pdexp) (importing and exporting table definition information, trigger definition information, or stored procedure information)
Figure 9-2 Overview of dictionary import/export utility (pdexp) (generating a definition SQL)