According to the documentation:
Note: dbimport cannot be used to move datablade data between Informix versions.
The supported process would be (in my understanding) an inplace upgrade of the existing 12.10 instance to the 14.10
version. (which would internally upgrade the datablade tables).
In case you are moving data to a different server, try to install the 12.10 edition there and make a full restore, followed
by an upgrade to 14.10.
Check the online.log for any errors during upgrade. The datablade data should be updated.
If you do a dbexport in the upgraded instance afterwards, the SQL file should contain references to the actual
version of the datablade.
Another approach would be to manually delete the datablade tables in the dbexport output (the .sql file) and restore without the
additional stuff, and the recreate the datablade in the database after loaded in the 14.10 version.
But the datablade typically will introduce column types etc. which are maybe used in your tables, so removing might not be so easy.
You could do a step-by-step approach by loading the tables which refer to datablade tables separately.
(remove these from the sql file and load the others first, then adding the datablade, then creating the special tables ....)
But this is definately more complex than an inplace-upgrade, which should do the conversion for you.
Hope this helps.
Original Message:
Sent: 2/16/2023 4:28:00 PM
From: Guillermo Giron Riveroll
Subject: -- Incompatible blade version to migrate a database from informix 12.10 FC15 to informix 14.10 FC9.
Hi everyone
I am trying to migrate a database from informix 12.10 FC15 on "server A" to informix 14.10 FC9 on "server B".
To extract the data, the command was used:
dbexport -d dsolutiondbs dsolution
And to import it I'm trying to use the command:
dbimport -d dsolutiondbs dsolution
But when it runs it gives me the following message:
create function "informix".calendarpatternout (CalendarPattern)
returns lvarchar with (not variant)
external name "$INFORMIXDIR/extend/TimeSeries.6.00.FC9/TimeSeries.bld(ts_cal_pattern_output)" language c;
-- Incompatible blade version (import TimeSeries.6.00.FC9; available TimeSeries.6.01.FC2)
Could you help me solve this please?
Thanks and regards
------------------------------
Guillermo Giron Riveroll
------------------------------