Re: Migrate from Informix to Oracle

i think you are really lucky today,
because i read your msg, while i am copying one informix table to my oracle db.
i hope you are on Unix, (cause we are :-) ) here we are migrating to oracle from informix too and i am also a member of conversion team...
i have written a batch file, which does the below, i just pass the arguments

Usage : inforacle <infdb> <infuser> <ousername> <opassword> <table> <infinstance> <oratnsentry> <delimeter> <query>

and it converts informix table structure to oracle and creates the oracle table and pumps the informix data to oracle via a unix pipe automatically...

you need nothing more...

now (22:45) i am pumping the largest table which has nearly 130 million rows in it (ohh dont worry, this is not the first time, we are at the third step)

performance ?
pumping 130 million rows takes nearly 36 hours... :-))

you can download this script from
http://members.nbci.com/hakan_yuksel/htmls/stuff.html

pls feel free to email me if you have any ques.

--
=====================================
Hakan Yuksel, Oracle DBA
TekstilBank - Istanbul, TURKEY
email:hyuksel_at_tekstilbank.com.tr
http://members.nbci.com/hakan_yuksel/
=====================================










In article <8vt4a6$lpe$1_at_seagoon.newcastle.edu.au>,
  "William Gardner" <wgardner_at_newcastle.edu.au> wrote:


> Dear All,


>

> I want to know if there is a tool from Oracle where I can convert my

> Informix DB to Oracle DB?

> I also want to know if there are commercial products for this kind of

 tools


> ?

>

> Thanks a lot

>

>






Sent via Deja.com http://www.deja.com/
Before you buy.