Re: DDL export

From: Dmitry <support_at_ispirer.com>
Date: Tue, 15 May 2001 14:12:18 +0300
Message-ID: <9dr30g$j6oii$1_at_ID-75577.news.dfncis.de>


Hi,

You can also use Chyfo (http://www.ispirer.com/products/) to retrieve DDLs from one database and convert them to other one. It supports converting DDLs between Oracle and DB2.

This is easy to use tool and it takes less than 100K on disk. For example,

chyfopro.exe /t=%.% /target=ora /ddl - will generate native Oracle CREATE TABLE and CREATE INDEX scripts for all tables from a database.

Best regards, Dmitry.

"christopher keller" <ckeller_at_acm.org> wrote in message news:4p6qft41n02acthl4q7id14bjqp12gs5mb_at_4ax.com...
> Hello,
> In UDB I can with one command generate a readable text file of DDL
> (along with triggers, etc.) for a database, which I can then easily
> manipulate and store it in a non-Oracle repository (with DB2 mainframe
> we'd just read the catalog with SQL if we didn't have a tool).
>
> My DBA for Oracle claims that this is not possible, he's come up with
> nothing better than an export file. Working this over is just too
> costly. Surely, this problem is easily solved with Oracle means.
> Could someone point me in the right direction? Or is the right
> direction away from Oracle to another RDBMS?
>
> TIA, Christopher Keller
Received on Tue May 15 2001 - 13:12:18 CEST

Original text of this message