Review the database schema prior to reversion
You must review your database schema to determine if reversion is possible. You can revert from Informix® Version 14.10 to the database server from which you migrated, if you have not added any extensions to the Version 14.10 database server and you are not reverting from a newly created instance.
To review the database schema to determine if reversion is possible:
- Run the dbschema utility command.
For example, run the following command to display information about the database db1:
dbschema -d db1 -ss - Determine if the schema file contains SQL statements that the earlier database server does not support.
- Determine if the database contains features, such as long identifiers, that the earlier database server does not support.
- Determine if any new SPL routines have been created in Informix Version 14.10 or if any routines were imported using dbimport.
- Determine if tables or indexes using expression fragmentation had expressions changed or new fragments added.
- Identify any new triggers, procedures, or check constraints.
See Reversion requirements and limitations for limitations on reversion to previous databases and prerequisite steps you must take before you revert.