Home | Previous Page | Next Page   Migration of Data Between Database Servers > Migrating Between Database Servers and Operating Systems >

Moving Data to a Database Server on a Different Operating System

This section describes the steps for moving data between Informix database servers on UNIX or Linux and Windows.

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, ON–Archive, or ontape to make a final level-0 backup.

    For more information, refer to your IBM Informix: Backup and Restore Guide or your IBM Informix: Archive and Backup 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.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]