Moving data to a database server on a different operating system

You can move data between HCL OneDB™ database servers on UNIX™ or Linux™ and Windows™.

About this task

Procedure

To move data to a database server on a different operating system:

  1. Save a copy of the current configuration files.
  2. Use ON-Bar to make a final level-0 backup.
    For more information, refer to your HCL OneDB Backup and Restore Guide.
  3. Choose one of the following sets of migration utilities to unload the databases:
    • dbexport and dbimport
    • UNLOAD, dbschema, and LOAD
    • UNLOAD, dbschema, and dbload
  4. Bring the source database server offline.
  5. Install and configure the target database server. If you are migrating to Windows, also install the administration tools.
  6. Bring the target database server online.
  7. Use dbimport, LOAD, or dbload, or external tables to load the databases into the target database server, depending on which utility you used to export the databases.
  8. Make an initial level-0 backup of the target database server.
  9. Run UPDATE STATISTICS to update the information that the target database server uses to plan efficient queries.