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.
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.

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

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.

After you ensure that client users can access data on the database server, the migration process is complete.

Next you might want to seek ways to obtain maximum performance. For details on topics related to performance, see your Informix® Performance Guide.