The dictionary import/export utility, the database reorganization utility, and the database load utility allow you to migrate a table that is currently in use to another HiRDB system. This facility can be used to achieve the following:

• Migrating a database from a test system to the actual system
• Migrating a database created in one HiRDB system to another HiRDB system
• During system reconstruction, storing existing database information and restoring it after the system has been reconstructed

As shown in the following table, two methods are available for migrating a table to another HiRDB system.

Table 12-1 Table migration methods

Condition		Migration method
RDAREA configurations of the source system and the target system	Is there an abstract data type column provided by a plug-in?
Same	No	Migrates table definition information and table data simultaneously.
	Yes	Migrates table definition information and table data separately.
Different	No
	Yes

Each of these methods is explained below.

Method that migrates table definition information and table data simultaneously

Executors: HiRDB administrator and table owner

This method uses the database reorganization utility and the database load utility to migrate table definition information and table data simultaneously. For the information that can be migrated and related details, see 12.1.2 Method that migrates table definition information and table data simultaneously.

Method that migrates table definition information and table data separately

Executor: HiRDB administrator

This method uses the dictionary import/export utility, the database reorganization utility, and the database load utility to migrate table definition information and table data separately.

For the information that can be migrated and related details, see 12.1.3 Method that migrates table definition information and table data separately.

Organization of this section

12.1.1 Migrating a table to another HiRDB system

12.1.2 Method that migrates table definition information and table data simultaneously

12.1.3 Method that migrates table definition information and table data separately

12.1.4 Example 1: Migrating table definition information and table data simultaneously

12.1.5 Example 2: Migrating table definition information and table data separately for each table

12.1.6 Example 2: Migrating tables of a schema

12.1.7 Example of a control statements file when migrating tables to a different schema

12.1.8 Example 4: Migrating a table containing binary data to a system that has a different endian format

12.1.9 Example 5: Migrating table data after expanding the column definition size of fixed-size character data

12.1.10 Actions to take when an error occurs during import