Data migration utilities
- External tables
External tables are a fast and versatile method for moving data between database servers. External tables are the fastest method for loading data into a RAW table with no indexes. - The dbexport and dbimport utilities
The dbexport and dbimport utilities import and export a database and its schema to disk or tape. - The dbload utility
The dbload utility loads data into databases or tables that IBM Informix products created. It transfers data from one or more text files into one or more existing tables. - The dbschema utility
The dbschema utility displays the SQL statements (the schema) that are necessary to replicate database objects. - The LOAD and UNLOAD statements
You can use the SQL LOAD and UNLOAD statements to move data. The LOAD statement is moderately fast and easy to use, but it only accepts specified data formats. You usually use the LOAD statement with data that is prepared with an UNLOAD statement. - The onunload and onload utilities
The onunload and onload utilities provide the fastest way to move data between computers that use the same database server on the same platform. - The onmode utility reversion option
You use the -b option of the onmode utility to revert to the older database server from which you converted. - The onrestorept utility
You can use the onrestorept utility to restore the database server back to the state that it was in just before the start of the failed upgrade.
Parent topic: Migrating Informix database systems