Re: Converting Designer ER diagram to DDL

many thanks Hilary, that was just what I was after !

Iain

hband_at_csc.com (Hilary Band) wrote in message news:<5b489863.0301200829.4c30fa8e_at_posting.google.com>...
> i.b.kerr_at_leeds.ac.uk (IKerr) wrote in message news:<83462b5a.0301200222.2a1997d_at_posting.google.com>...
> > Hi,
> >
> > I have done an ER diagram with Oracle 9i Designer and now want to
> > transform it into a database - ie get oracle to generate the DDL for
> > me. How can I do this ? I have looked at the Database Design
> > Transformer and Design Editor (don't know what the difference between
> > them is), but I am a bit lost. Could someone help please.
>
> Use the Database Design Transformer to transform your entity model
> into tables. When the run is complete, go into the Design editor and
> look on the Server Model tab. There you will see the resulting
> tables. At this point you can edit the various things such as column
> names (Designer generated ones tend to have very awkward names!),
> various object properties etc.
>
> Once you have these tables you should create a database on the DB
> Admin tab and in that database create the user that you want to own
> the tables. You then need to create table implementations for that
> user. Open the user, schema objects, table implementation and click
> on the green cross.
> >
> > Also does Oracle provide an intermediate step so that changes to the
> > DDL can be made between Designer & DDL output (ie to tweak the design
> > / change keys & entities etc), or do you have to do all that in
> > Designer ? I posted this on another group, but it seems to have got
> > buried at the bottom of an un-related thread!
> >
>
> You can generate the DDL to script files which you can then edit as
> you wish.
>
> > Another question. I have some sub & supertypes in the ER diagram.
> > Should I specify the PK & FK in the diagram before conversion ? If so
> > how do I specify the FK (I can only see tickboxes for PK) ?
> >
>
> The FKs will be picked up and generated from your entity model - this
> is where the awkwardly named columns comes in!
>
> HTH
>
> H
Received on Tue Jan 21 2003 - 23:57:13 CET