Re: Moving schema from DB2 to Oracle9i

Hi,

First try Oracle Migration Workbench, it's a free tool.

Manual conversion is a complex task, since you need to convert data types, date/time conversion, constraints, resolve possible reserved word and identifier conflicts, create various control files. If you have LOBs, it will not be easy to create SQL Loader scripts.

If OMWB has any issues, try commercial products - usually they cover more issues and fully automate the schema and data conversion.

Best regards, Dmitry Tolpeko
SQLWays - Data, Schema, Procedures conversion between Oracle, SQL Server, DB2, Sybase, Informix, MySQL
www.ispirer.com

"Mark D Powell" <Mark.Powell_at_eds.com> wrote in message news:1104886950.880481.229170_at_f14g2000cwb.googlegroups.com...
> I agree with Harry. Just dump the data into a delimited file, FTP that
> to the Oracle box, use sqlldr. Simple.
>
> You might need to do a little data manipulation on the DB2 side to
> convert some of the data into a form that is a better fit with Oracle
> such as formatting separate DB2 date and time columns into one field in
> the delimited file.
>
> HTH -- Mark D Powell --
>
Received on Wed Jan 05 2005 - 11:59:18 CST