RE: Looking for database design/model software

["Ben Yau" <byau cardcommerce com>]

On Behalf Of Reuben D. Budiardja
> Sent: Monday, February 09, 2004 10:27 AM
> To: redhat-list redhat com
> Subject: Re: Looking for database design/model software
>
> > >
> >
> > Does anyone here know of a database design/modeling software
> that runs on
> > redhat?  Preferably free?  At the least I would need is just
> something to
> > draw the diagrams with and put in the table information.  If it could
> > generate SQL, that's a huge huge plus.
>
> I use Dia (http://www.lysator.liu.se/~alla/dia/), which is included in RH
> distro, to draw diagram for the tables relationship in my
> database. Since Dia
>
> [snip]
>
> If I understood you correctly, what you want seems to be the
> other way around.
> You want to draw and put in the table information graphically, and then
> generate the SQL script. It should not be very hard to write a
> script that
> takes the XML file of Dia and turn it into SQL file.
>
> By the way, what database are you using? If you're using
> PostgreSQL,

Hi!  Thanks for your email.  I snipped your reply a bit.  My priority is
just to find the diagramming tool.  Generating SQL, though very convenient,
it not a necessity. I actually would be using this for come various current
and future projects (so that means a variety of db) so that is why the SQL
generation is not a necessary.  I like Datanamic's Dezign because it actualy
supports a lot of different databases for SQL generation (it runs on windows
and costs $300).  I'll look into dia and see if I can find it on my redhat 8
cd's.

-Ben