Moving Data From Informix 5.x to 9.x Which utility works best
Joseph Dixon asked which utility to use to migrate data from Informix 5.x to a 9.3 server. Paul Watson recommended dbexport because the schema can be tweaked, though it needs disk space. Phil Rule warned an .unl file over 2 GB will not be written. David Williams suggested myschema and dbcopy from the IIUG utilities, then recreating indexes with PSORT_NPROCS for fast builds.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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 #
>
>