Re: Reverse engineer Oracle 8.1.7 and recreate problems

From: Stefan Heckler <sheckler_at_psi.de>
Date: 28 May 2002 05:33:10 -0700
Message-ID: <3e19f7c8.0205280433.66ba8b68_at_posting.google.com>


I begin like that

-->Capture Design of
-->Server Model from database -> ok
-->Capture Implementation into DEFAULT DATABASE AS DEFAULT USER ->
-->Retrofit Tables to Entities -> ok
-->Run Database Design Transformer (here the problems occur) to
recreate/change table/index/key definitions

Mike Alba <mike_at_netplasma.com> wrote in message news:<3CEC2BBB.20005_at_netplasma.com>...
> Can I ask how you did the regeneration in
> Designer 6i? I assume you are using
> from the Menu
> -->Generate
> -->Capture Design of
> -->Server Model
> Then you are selecting from a database?
> Because there you can specify which
> objects to capture?
>
> Stefan Heckler wrote:
>
> > Hi all,
> >
> > I try to reverse engineer an oracle 8.1.7 database with designer 6i
> > and table to er retrofit tool. The reverse engineering workes quite
> > fine, but the tables I regenerate from the ER model are not as
> > expected: The table names are renamed to their plural name, indexes
> > are generated, that I do not want. Is there any documented way to get
> > exactly the same out, which was reverse engineered?
> > I would like to maintain my data model as ER diagramm and regenerate
> > the database with sequences, indexes, primary and foreign keys from
> > the ER model.
> > But first it must work to reverse engineer an existing database and
> > regenerate exactely the same database with exactly the same indexes
> > (same names), which I did not succeed in so far. Has anybody already
> > experience with this kind of stuff?
> > Any documentation hint very welcome
> > Thanks
> >
> > Stefan Heckler, PSI AG (sheckler_at_psi.de)
> >
Received on Tue May 28 2002 - 14:33:10 CEST

Original text of this message