Choosing a tool for moving data before migrating between operating systems

If you are migrating between different operating systems, you must choose a method for exporting and importing data. The tool that you choose for exporting and importing data depends on how much data you plan to move.

All these methods deliver similar performance and enable you to modify the schema of the database. The tools that you can use include:

• The dbexport and dbimport utilities, which you can use to move an entire database
• The UNLOAD and LOAD statements, which move selected columns or tables (The LOAD statement does not change the data format.)
• The dbload utility, which you can use to change the data format
• The High-Performance Loader (HPL), which moves selected columns or tables or an entire database
• Enterprise Replication, which you can use to transfer data between HCL OneDB™ on one operating system and HCL OneDB on a second operating system.