 | | | Looking for database design/model software | Looking for database design/model software 2004-02-11 - By Reuben D. Budiardja
Back
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@(protected)?subject=unsubscribe
https://www.redhat.com/mailman/listinfo/redhat-list
|
|
|