Hello,

d'ya know any MySQL DDL -> HTML conversion tool? We'd like to generate
some developer docs using an existing MySQL DDL (SQL) file including
comments.

Thanks in advance,
Keep smiling
yanosz

Jan Luehr wrote:

No.

Good luck.

--
PointedEars

Bitte keine Kopien per E-Mail. / Please do not Cc: me.

On 5/7/2011 4:12 PM, Jan Luehr wrote:
Not MySQL specific, I don't. But if you're using pretty much standard
SQL (few MySQL extensions), some of the standard conversion tools might
work.

I don't use them myself - I seldom generate HMTL from my DDL. I prefer
pretty pictures.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex (AT) attglobal (DOT) net
==================

On 2011-05-07 22:12, Jan Luehr wrote:
Not exactly what you asked for, but schemaspy does a pretty god job on
documenting schemas (http://schemaspy.sourceforge.net/).



/Lennart

On Sat, 07 May 2011 22:12:02 +0200, Jan Luehr wrote:

Maybe what your are looking for is MySQL Workbench SE (not GA). I think
it costs about $100 and, unforunately, the GA version number is past the
SE version number. It has tools for creating all sorts of documentation,
including HTML, from your schema.

Jan Luehr <jan (AT) stephan (DOT) homeunix.net> wrote:
What should that be? Maybe like so?

(echo "<pre>"; cat $SQLFILE; echo "</pre>") > $HTMLFILE

The preferred way to document a relational schema is an ER diagram.
Applications of the "Data Modeller" kind (MySQL Workbench, DB-Designer,
TOAD, etc.) can do that. Some can even "guess" the ER from DDL.

But the typical workflow is in the other direction: create the data
model with comments and have DDL generated from it.


XL