Have you looked at using tools like Oracle EDMS, SmartDb by Smart Corp,
Constellar by Constellar or Prizm. All of them good data movement tools but
not other database objects. Check them all out and pick the one that suits
your needs. Only EDMS and Constellar can read from an Informix database
through gateways other two need the input as flat files.
nasof_at_hotmail.com wrote in message <6q75e1$cnj$1_at_nnrp1.dejanews.com>...
>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 Wed Aug 05 1998 - 15:08:53 CDT
