On Monday 09 February 2004 12:13 pm, Ben Yau wrote: > Hi all. > > > 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 file is XML based, I actually have a small PHP script that takes the input of a SQL file containing description or SQL script to create the tables, and feed it into another script that turns it an XML file for Dia. I then open the XML file using Dia and all I need to do is to draw the relationship connector, since I'm lazy to actually type in anything into Dia (I'd rather write the SQL script to create tables). The PHP script is not perfect and has its idiosyncrazy (sp?) , but it does the job for me to generate a rather nice looking documentation. You may contact me offlist if you wish. 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, there is pgaccess. If you're using Oracle, you may want to check "Tora" out. I've never actually use those tools for designing other than as a nice simple GUI interface to quickly lookup my table description since I'm more of a SQL console user. Hope that helps. RDB -- Reuben D. Budiardja Department of Physics and Astronomy The University of Tennessee, Knoxville, TN --------------------------------------------------------- "To be a nemesis, you have to actively try to destroy something, don't you? Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect." - Linus Torvalds - -- redhat-list mailing list unsubscribe mailto:redhat-list-request@xxxxxxxxxx?subject=unsubscribe https://www.redhat.com/mailman/listinfo/redhat-list
