On Wednesday 11 February 2004 11:57 am, Ben Yau wrote: <snip> > Cheers people. Thanks to everyone for their responses. > By the way, I did work on dia a little bit and it wasn't what what I was > looking for . Unless I missed something, it seemed more like a basic > diagram tool (and a good one at that) but not a good ERD tool. I wasn't very obvious to me at the first time to use Dia for ERD, so I guess I should have been more explicit. What I did is I select the "UML" from the drop-down "category" (or whatever it's called), and then create a Class, which I can edit to show my table structure. Dia can export to ps/eps, svg, png (which of course can be converted easily to anything). Here is an output example. The tables structure (eg column name, datatype, + to indicate primary key) are generated automatically by my script. All I needed to do is put them in a better layout and draw the arrows, which was very easy. http://arcturus.phys.utk.edu/~reubendb/erd_potholes.ps Your question actually gave me an idea of working on disconstructing the XML output from Dia and generate a SQL statement. Should be a fun exercise for parsing XML :) 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
