Re: Migration Of Data ...

namita@tulnepz.unisys.com wrote: :} Hi, :} :} We are currently working on a migration project involving database :} migration from RDMS(2200) to informix. :} :} The functionality involves making a copy of the whole database every :} evening so that the batch programs are run on the copied database :} throught out night. I understand there are certain utilities like :} dbimport/dbexport etc in informix. Has anyone used them extensively ?. :} Which one is the most efficient ?. dbimport/dbexport are for use to/from Informix databases only. dbexport generates the data in a special format that dbimport understands. For import from other databases dbload is the standard tool. On the newest versions of Informix OnLine (7.?) there is also a new parallell loader that is more efficient. Nils.Myklebust@ccmail.telemax.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company