Re: db documentation html
Posted by: Dan P
Date: January 29, 2008 12:50PM

You can use a database modeling tool for this. Generating reports, diagrams, etc is one of the basic features of any such tool.

I'm advocating ModelRight (www.modelright.com) which I consider the best for MySQL.

It has a free version for MySQL. If you use the free version, Reporting is a two steps process.
After you connect to the database, reverse engineer your database (and end up with a nice graphical view of your database), then you will have to generate the model as a XML file (see Export to XML feature). Then at a command prompt, you can run something like: xsl "Model Report.xsl" yourmodelasxml.xml > yourreportfile.html, where "Model Report.xsl" is the XSLT file that comes with MR (found in the Reports folder). Replace xsl with whatever XSLT generator you want to use.
The commercial version obviously does that automatically for you.

Hope this helps.

Options: ReplyQuote


Subject
Written By
Posted
January 29, 2008 08:40AM
Re: db documentation html
January 29, 2008 12:50PM
January 30, 2008 02:57AM
January 30, 2008 12:43PM
February 17, 2008 08:21PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.