Jump to main content
Product Documentation
Customer Support
HCL Informix V14.10
HCL Informix®
V
14.10
documentation
Product overview
Installing
Administering
Migrating
Informix®
database systems
Client APIs and tools
Embedding
Informix®
Extending
Informix®
Data warehousing
Designing databases
JSON compatibility
Security
SQL programming
Troubleshooting
Informix®
Informix PDF guides
Search
Home
Migrating
Informix®
database systems
These topics describe how to migrate to a new version of
HCL Informix®
and how to revert to the database server that you migrated from. These topics also describe how to move data manually between databases, servers, and computers.
Data migration utilities
Migrating
Informix®
database systems
These topics describe how to migrate to a new version of
HCL Informix®
and how to revert to the database server that you migrated from. These topics also describe 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
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
HCL® 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.
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
HCL® 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.
Rate this topic
5 stars
4 stars
3 stars
2 stars
1 star
Comment on this topic.
By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at
https://hcltechsw.com/resources/us-government-contact
. Do not include any personal data in this Comment box.