Re: converting from Informix to Oracle

Hi Gopinath,

I haven't heard of any that fully automate the process. After looking for some aids I wound up doing the following:

1. run oncheck agains the informix database
2. edit the output of the oncheck to suit Oracle DDL
3. build a script to unload each of my tables and run same
4. ftp the output to the Oracle box
5. run the script created in step 2 to create all of the tables
6. use the editor to copy and transform the create scripts into sqlloader control files
7. load the tables

Phew!

If you are proficient with an editor with good macro capabilities, such as vi or emacs, this isn't as hard as you might think. I was able to move about 200 tables in one week. The bulk of the time was spent on resolving the differences between Informix and Oracle (particularly dates and varchar) and in regenerating the constraints.

regards

Jerry

O S Gopinathan wrote:
>
> Hello,
>
> I am looking for an automated method of converting an Informix database
> (large/ complex ) to Oracle 7/8 database.
>
> Is there any tool available in the market to automate the entire process?
>
> Thanks,
>
> Gopinath

--

Jerry Gitomer         	ICT Group
jgitomer_at_ictgroup.com	Langhorne PA
jgitomer_at_yahoo.com 	Opinions are mine not those of ICT Group