Home
Migrating and upgradingYou 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 systemsThe Informix® Migration Guide describes how to move data manually between databases, servers, and computers.
Data migration utilities
The onunload and onload utilitiesThe onunload and onload utilities provide the fastest way to move data between computers that use the same database server on the same platform.
Syntax of the onunload commandThe onunload command unloads data from a database and writes a database or table into a file on tape or disk.
Data that is unloaded with a tableIf you unload a table, onunload unloads the table data and information from the systables, systables, syscolumns, sysindexes, and sysblobs system catalog tables.

Data that is unloaded with a table

If you unload a table, onunload unloads the table data and information from the systables, systables, syscolumns, sysindexes, and sysblobs system catalog tables.

When you unload a table, onunload does not unload information about constraints, triggers, or default values that are associated with a table. In addition, access privileges that are defined for the table and synonyms or views that are associated with the table are not unloaded.

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.