Re: any tool for conversion?
Date: Fri, 18 May 2001 13:48:14 GMT
Message-ID: <yK9N6.14266$Az.1317059_at_newsread2.prod.itd.earthlink.net>
Dmitry
Get a good Modelling tool for forward/reverse engineering supporting
multiple databases. CA Erwin comes to mind. www.ca.com You method will
work on the cheap some hand editting of the DDL file extracted for DB2 may
be necessary.
hth
Dave Fowler
"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 - 15:48:14 CEST