Using a LaTeX or similar text-macro tool/library, how can I generate an Entity-Relationship Diagram then generate SQL from it?
-
1Can you post a bit more detail as to exactly what you want. Perhaps a diagram and some code of what you have attempted.– Peter GrillSep 15, 2011 at 2:02
-
1IMHO, TikZ is the way to go for diagrams: See typesetting uml class diagrams for more options.– Peter GrillSep 15, 2011 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 TSep 19, 2011 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 TSep 19, 2011 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?– SeamusSep 20, 2011 at 14:07
1 Answer
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.