Re: any tool for conversion?
Date: Fri, 18 May 2001 20:31:02 +0300
Message-ID: <9e3man$mhvh$1_at_ID-75577.news.dfncis.de>
Hi,
Use migration tool Chyfo (http://www.ispirer.com/products/) It does what you need.
It converts Oracle tables to text files, generates native CREATE TABLE, CREATE INDEX, IMPORT/LOAD scripts for DB2.
It is easy to use and has small size (about 40K). For example, chyfopro.exe /d=ora_base /t=%.% /target=db2 will convert all tables from Oracle and generate native scripts for DB2.
Best regards, Dmitry.
"Dmitry V Petrovsky" <Dmitry.Petrovsky_at_irboard.net> wrote in message
news:3b050fc0$1_at_e-post.inode.at...
> Dear All,
>
> I have Oracle 8.0.5 and my task to recreate the same database on DB2.
> The only way out I see is in perl script which look through the Oracle
> database
> and puts all the data in the text file. Then according to Oracle desc
> command -
> recreate all the table in DB2. But... I have doubts that it is the most
> intellegent
> and efficient way.
> Any hints?
>
> --
> Yours truly,
> Dmitry Petrovsky
>
>
Received on Fri May 18 2001 - 19:31:02 CEST