Re: Migrating HPL jobs
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
> [mailto:owner-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