Home
Migrating and upgrading
You can upgrade to the 14.10 release of HCL Informix® or migrate from other database servers to Informix. Upgrading is an in-place migration method that uses your existing hardware and operating system software. Some changes to the Informix database server can affect upgrading from a previous release.
Migrating Informix® database systems
The Informix® Migration Guide describes how to move data manually between databases, servers, and computers.
Migration of data between database servers
Migrating database servers to a new operating system
When you migrate to a new operating system, you must choose a tool for migrating your data, you might need to make some adjustments to your tables, and you must review environment-dependent configuration parameters and environment variables.
Moving data to a database server on a different operating system
You can move data between Informix® database servers on UNIX™ or Linux™ and Windows™.

Migrating and upgrading
You can upgrade to the 14.10 release of HCL Informix® or migrate from other database servers to Informix. Upgrading is an in-place migration method that uses your existing hardware and operating system software. Some changes to the Informix database server can affect upgrading from a previous release.
- Migrating Informix® database systems
  The Informix® Migration Guide describes how to move data manually between databases, servers, and computers.
  - Overview of migration
  - Migration to and reversion from 14.10
  - Migration of data between database servers
    - Migrating database servers to a new operating system
      When you migrate to a new operating system, you must choose a tool for migrating your data, you might need to make some adjustments to your tables, and you must review environment-dependent configuration parameters and environment variables.
      - 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.
      - Adjusting database tables for file-system variations
        File system limitations vary between NFS and non-NFS file systems. You might need to break up large tables when you migrate to a new operating system.
      - Moving data to a database server on a different operating system
        You can move data between Informix® database servers on UNIX™ or Linux™ and Windows™.
      - Adapting your programs for a different operating system
        When you change to a different operating system, you must review and, if necessary, adjust your environment-dependent configuration parameters and environment variables.
      - Ensuring the successful creation of system databases
        The first time the database server is brought online, the sysmaster, sysutils, sysuser, and sysadmin databases are built. After moving to a database server on a different operating system, check the message log to ensure that the sysmaster and sysutils databases have been created successfully before you allow users to access the database server.
  - Data migration utilities

Moving data to a database server on a different operating system

You can move data between Informix® database servers on UNIX™ or Linux™ and Windows™.

About this task

Procedure

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

Save a copy of the current configuration files.
Use ON-Bar or ontape to make a final level-0 backup.
For more information, refer to your Informix® Backup and Restore Guide.
Choose one of the following sets of migration utilities to unload the databases:
- dbexport and dbimport
- UNLOAD, dbschema, and LOAD
- UNLOAD, dbschema, and dbload
Bring the source database server offline.
Install and configure the target database server. If you are migrating to Windows™, also install the administration tools.
Bring the target database server online.
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.
Make an initial level-0 backup of the target database server.
Run UPDATE STATISTICS to update the information that the target database server uses to plan efficient queries.

Results