i am not sure if there are utilities/documents to do this, but i had done this few years ago with success. basically, i manually (using a program/script) inserted records in the onpload database, this method may not be supported by informix but it worked for me, here is what i did,

- unload data from the following tables project,device,query,formats,maps & session from onpload database

- write a script to read the unloaded data and insert the data in the existing onpload database, in the following tables (the order is important)
a. project
b. device
c. query
d. formats
e. formatitem
f. maps
g. mapitem
h. session

- you have to be very careful with the serial key columns, basically let the engine generate the serial key value for you during the insert, for e.g. when you insert a row in the project table make sure the projectid is generated by the engine, then you can use the projectid to insert rows in the other tables (query,maps,session....), you will have to do the same for the other serial key (formid, formatid...) columns

- make sure to take a backup of the onpload database before doing this migration.

- also, this procedure is risky, and may not be supported by informix.



-----Original Message-----
From: owner-informix-list@iiug.org
[mailtowner-informix-list@iiug.org]On Behalf Of Andy Kent
Sent: Tuesday, March 01, 2005 5:20 AM
To: informix-list@iiug.org
Subject: Migrating HPL jobs


I need to migrate a set of HPL jobs from a dev to a production box, but
I don't want to overwrite the jobs that are already on the production
box (so dbexport / dbimport are no good).

Can someone point me in the direction of a utility / piece of SQL / bit
of documentation to help do this?

Thanks

Andy Kent


sending to informix-list

Why the heck is export /import no good??

you could use:

export DBONPLOAD=superboer

start ipload and it will create a db called superboer with all the
tables.
or grab an export of your production,
rename the onpload.exp dir and sql file to something else,
import it and set DBONPLOAD.

See you

Superboer.

"Savio Pinto \(s\)" <spinto@cap.org> wrote in message news:<1109783430.ac3947a359eb97083d8d5e0bff7a63ef@ teranews>...
> i am not sure if there are utilities/documents to do this, but i had done this few years ago with success. basically, i manually (using a program/script) inserted records in the onpload database, this method may not be supported by informix but it worked for me, here is what i did,
>
> - unload data from the following tables project,device,query,formats,maps & session from onpload database
>
> - write a script to read the unloaded data and insert the data in the existing onpload database, in the following tables (the order is important)
> a. project
> b. device
> c. query
> d. formats
> e. formatitem
> f. maps
> g. mapitem
> h. session
>
> - you have to be very careful with the serial key columns, basically
let the engine generate the serial key value for you during the
insert, for e.g. when you insert a row in the project table make sure
the projectid is generated by the engine, then you can use the
projectid to insert rows in the other tables (query,maps,session....),
you will have to do the same for the other serial key (formid,
formatid...) columns
>
> - make sure to take a backup of the onpload database before doing this migration.
>
> - also, this procedure is risky, and may not be supported by informix.
>
>
>
> -----Original Message-----
> From: owner-informix-list@iiug.org
> [mailtowner-informix-list@iiug.org]On Behalf Of Andy Kent
> Sent: Tuesday, March 01, 2005 5:20 AM
> To: informix-list@iiug.org
> Subject: Migrating HPL jobs
>
>
> I need to migrate a set of HPL jobs from a dev to a production box, but
> I don't want to overwrite the jobs that are already on the production
> box (so dbexport / dbimport are no good).
>
> Can someone point me in the direction of a utility / piece of SQL / bit
> of documentation to help do this?
>
> Thanks
>
> Andy Kent
>
>
> sending to informix-list