Generate Entity-Relationship Diagram then generate SQL from that

Question

Using a LaTeX or similar text-macro tool/library, how can I generate an Entity-Relationship Diagram then generate SQL from it?

Can you post a bit more detail as to exactly what you want. Perhaps a diagram and some code of what you have attempted. — Peter Grill, Sep 15 '11 at 2:02
IMHO, TikZ is the way to go for diagrams: See typesetting uml class diagrams for more options. — Peter Grill, Sep 15 '11 at 2:28
I've decided to write the SQL by hand, and generate a diagram from that using SchemaSpy. Using Doc2TeX I can then embed it neatly into my TeX report. — A T, Sep 19 '11 at 11:34
But I want people to mark it down if they think it's a bad idea, or mark it up if they think it's a good one — A T, Sep 19 '11 at 15:06
This seems like the wrong way round. Wouldn't it be easier to write the SQL and then read that to create the diagram? Or have I misunderstood something? — Seamus, Sep 20 '11 at 14:07

user2478user2478 · Accepted Answer · 2011-09-15 07:29:20Z

1

Run texdoc pst-dbicons then you'll get the documentation of pst-dbicons. But there is no package which can generate the corresponding sql code.

answered Sep 15 '11 at 7:29

user2478

add a comment |

1 Answer 1