At 01:15 PM 7/9/2002, you wrote: >Hello list. > >At the end of a db programming job (using php) I have been asked for a >document describing in details the structure of a MySQL database. >The purpose of the document is to make other DB people able to manage and >interface the database (I can figure out that there is also the intent to >impress the customer by graphic and heavy paper). >Could you please suggest me some source where I could learn about the best >standard methods to describe a DB structure ? >Is there any tool which is able to produce this kind of document >semi/automatically ? > >gg >
gg, Try Visiomodeler from MS. Download at http://download.microsoft.com/download/visio2000enterprise/ORMtool/3.1/WIN98/EN-US/msvm31.exe. Use ODBC to access MySQL. It can reverse engineer your MySQL database and can generate SQL to build your database. Oh yeah, one more thing, it's free. :) It also has excellent PDF documentation on how to use case tools. Also if you just want to report on the structure, try MySQLFront from http://www.anse.de/mysqlfront/. Also EMS MySQLMgr has much better reporting and you can get a 30 day eval from http://ems-hitech.com/mymanager/. Mike --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php