Re: Reverse engeneering : a way to get the DB shema

Some good product mentioned in the other posts. Don't forget Visio and Erwin. I like DBArtisan best but...

--

Mark Lewis
President
Mark D. Lewis Inc.
mdlewis_at_mdlewis.com
"Eric Nguyen" <nguyenq_at_supernet.ca> wrote in message
news:AxXA6.57$GT5.5672_at_quark.idirect.com...


> Sebastien,


>    You can download Toad from Quest, they have a free version (at least

 good


> for one


> month) . It can generate DDL from your schema. It does exactly what you

 want


> and probably more.


>

> "Tom Grenier" <tom_at_sqlman.com> wrote in message

> news:3AD20302.38510D42_at_sqlman.com...

> > Sebastien,

> >

> > This was one of my largest frustrations with Oracle (I am switching to

> > Oracle but have primarily been an Informix person).  Informix does this

> > with the dbschema command -- it creates an actual DDL script, but I use

 it


> > primarily as a DESCRIBE as I like to work with a paper description of


 the


> > database (with more detail than DESCRIBE gives).


> >

> > Anyway, I wrote a small procedure in PL/SQL to do this.  It DOES NOT

 create


> > an executable .sql file -- if this is what you need it won't do it.


> > However, if you want a schema of the database that gives constraints,

> > indexes etc. it may to the trick.

> >

> > If you have any interest in it you can download it from my web site --

> > www.sqlman.com -- first item on the SQL Puzzles page.  No guarantees

 that


> > it works as it should -- I've tested on 8i on NT (appears to work fine)

 and


> > 7 on Solaris (misses a lot of the constraints but otherwise seems to

 work


> > fine).


> >

> > Or feel free to use it as a starting point for what you need.

> >

> > Tom

> >

> > Sebastien Le Floc'h wrote:

> >

> > > Hi, I've got a db on oracle 8.i and we're looking for a soft that

 could


> > > connect the db and do the DB shema (merise....)


> > > Any idea welcome

> > > Thanks a lot

> >

>

>

>