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.
Migration to and reversion from 14.10
Reverting from Informix® Version 14.10You can revert to the version of the database server from which you migrated. When you run the reversion utility, you specify the target server for reversion and then Informix® checks your database. If necessary, Informix® might tell you to drop new objects, before automatically converting your data into the target server.
Reverting from Informix® Version 14.10After preparing to revert, run the reversion utility and prepare to use the original database server.
Add JSON compatibility to databases that were created in 12.10.xC1Databases that were created in Informix® 12.10.xC1 are not JSON compatible. In 12.10.xC2 or 12.10.xC3 you can run a script to make those databases JSON compatible. You do not have to run the script after you upgrade to 12.10.xC4 or later fixpacks because all databases are made JSON compatible during conversion.

Add JSON compatibility to databases that were created in 12.10.xC1

Databases that were created in Informix® 12.10.xC1 are not JSON compatible. In 12.10.xC2 or 12.10.xC3 you can run a script to make those databases JSON compatible. You do not have to run the script after you upgrade to 12.10.xC4 or later fixpacks because all databases are made JSON compatible during conversion.

Before you begin

This procedure requires Informix 12.10.xC2 or 12.10.xC3.

You must run the script as user informix or as a user with DBA privileges.

Procedure

Run the appropriate script against a database that was created in Informix 12.10.xC1 to make the database JSON compatible.

Informix 12.10.xC3: convTovNoSQL1210.sql
Informix 12.10.xC2: convTovNoSQL1210X2.sql

For example, to make the db_name database JSON compatible in Informix 12.10.xC3, you would run the following command as user informix or as a user with DBA privileges:

UNIX™: dbaccess -e db_name $INFORMIXDIR/etc/convTovNoSQL1210.sql
Windows™: dbaccess -e db_name %INFORMIXDIR%\etc\convTovNoSQL1210.sql

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.