Re: migrating from DB2/2 to Oracle 8.1.7

Hi,

Take a look at Chyfo (http://www.ispirer.com/products/) This is a migration tool that can easily move your DB2 database into Oracle.

Chyfo can export a DB2 database to text files, generate native DDL scripts for Oracle (CREATE TABLE, CREATE INDEX), generate control files for loading data using Oracle SQL Loader.
It supports moving of LOBs.

Best regards, Dmitry.

"Ed Stevens" <Ed_Stevens_at_nospam.noway.nohow> wrote in message news:3b252654.2906118_at_ausnews.austin.ibm.com...
> We have an application currently running against a DB2/2 (OS/2 --
> predecessor to DB2-UDB) database. One phase of a 3-phase upgrade will
> be to convert the database to Oracle 8.1.7 running on NT4. The major
> data concern will be the handling of dates and times -- converting
> columns defined as DB2's DATE and TIME and TIMESTAMP types to Oracle's
> single DATE type.
>
> We had a system go through this a couple of years ago and the
> application programmers handled the conversion themselves, writing
> programs to extract and reformat the data from DB2/2 and write to a
> flat extract file, then read that file and insert into empty Oracle
> tables. Obviously, we'd like to find a pre-packaged utility to do
> this. Does anyone know of any such creature? I've done some poking
> around on Oracle's web site and couldn't find anything, but that
> doesn't mean it's not there . . .
> --
> Ed Stevens
> (Opinions expressed do not necessarily represent those of my employer.)
Received on Tue Jun 12 2001 - 04:40:54 CDT