You can move data between Informix® database
servers on UNIX or Linux and Windows.
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 HCL
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.