Re: converting from Informix to Oracle

Personally, I would want to do this manually. I would be shocked if there was a tool available. For instance, in informix the max varchar is 255. Do you want a CHAR(2000) to be converted to CHAR(2000) in Oracle, or would you prefer it as VARCHAR2(2000)? In informix there are SERIAL datatypes. DO you want them to be converted to NUMBER? or do you need to add a sequence to take care of the previous SERIAL number?

IF you have a large an complex database, why do you want some tool to do the conversion for you? Don't you want to create an optimal Oracle DB?

Other considerations include Fragmentation in Informix vs. Partitioning in Oracle. Also all stored procs will have to be re-created in PL/SQL.

Why not start with a "dbschema" output and make global replacements on things like SERIAL, etc... Most of the "create table" output should be similar to Oracle.

-Frank

In article <6q6sjf$49o$1_at_maple.cgin.us-md.citicorp.com>,   "O S Gopinathan" <gopinath_at_citicorp.com> 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
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Aug 04 1998 - 09:21:54 CDT