Moving Data From Informix 5.x to 9.x Which utility works best

I am moving informix 5.x to informix 9.x which utility works best for migrating the data. The server is already upgraded to 9.3 I need to know which utility to use to migrate my database. tbtape to onbar tbunload to onload or something like that... has anybody upgrade from that far down before.

I'd use dbexport as it allows me to the tweak the database schema. But you might need quite a bit of disk:-)) Joseph Dixon wrote: > > I am moving informix 5.x to informix 9.x which utility works best for > migrating the data. The server is already upgraded to 9.3 I need to know > which utility to use to migrate my database. > > tbtape to onbar > tbunload to onload or something like that... > has anybody upgrade from that far down before. -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com #

The only caveat to that would be if there's any *huge* tables, resulting in an '.unl' file >2gb - Informix won't write such a file to disk. -- Phil@oninit.com Paul Watson <paul@oninit.com> wrote in message news:3EE5DBA7.59DF1CE4@oninit.com... > I'd use dbexport as it allows me to the tweak the database schema. But > you might need quite a bit of disk:-)) > > Joseph Dixon wrote: > > > > I am moving informix 5.x to informix 9.x which utility works best for > > migrating the data. The server is already upgraded to 9.3 I need to know > > which utility to use to migrate my database. > > > > tbtape to onbar > > tbunload to onload or something like that... > > has anybody upgrade from that far down before. > > -- > Paul Watson # > Oninit Ltd # Growing old is mandatory > Tel: +44 1436 672201 # Growing up is optional > Fax: +44 1436 678693 # > Mob: +44 7818 003457 # > www.oninit.com #

"Phil Rule" <phil.rule@ntlworld.com> wrote in message news:b3mFa.2930$Cm5.720006@newsfep2-win.server.ntli.net... > The only caveat to that would be if there's any *huge* tables, resulting in > an '.unl' file >2gb - Informix won't write such a file to disk. > Go to www.iiug.org and get Software -> utils_ak2. Use myschema to get a schema of the database without indexes/constranits. Modify schema to create tables in correct dbspaces/with correct extent sizes. Use dbcopy to copy the data across Use myschema to get indexes/contraints. Create these using PSORT_NPROCS etc to get fast parallel index builds/ fast constraint creation. > -- > Phil@oninit.com > > Paul Watson <paul@oninit.com> wrote in message > news:3EE5DBA7.59DF1CE4@oninit.com... > > I'd use dbexport as it allows me to the tweak the database schema. But > > you might need quite a bit of disk:-)) > > > > Joseph Dixon wrote: > > > > > > I am moving informix 5.x to informix 9.x which utility works best for > > > migrating the data. The server is already upgraded to 9.3 I need to know > > > which utility to use to migrate my database. > > > > > > tbtape to onbar > > > tbunload to onload or something like that... > > > has anybody upgrade from that far down before. > > > > -- > > Paul Watson # > > Oninit Ltd # Growing old is mandatory > > Tel: +44 1436 672201 # Growing up is optional > > Fax: +44 1436 678693 # > > Mob: +44 7818 003457 # > > www.oninit.com # > >