Re: Database documentation
Hi, These tools are not open source: http://www.thekompany.com/products/dataarchitect/ You can download the evaluation. It supports MySQL directly: http://www.datanamic.com/download/download_dezign.html If you are not familiar with database methodology and relation entity diagrams, I recomend you to buy a book that explains the concept a little bit. Bye and good luck. --- Gigi Di Leo [EMAIL PROTECTED] 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 - 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 __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com - 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
Re: Database documentation
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
RE: database documentation
hi. i went looking all over the place for an ER diagramming tool that could read mysql dumps, and found this: http://www.datanamic.com/importerscripts/ which will connect to a mysql database and generate a diagram, guessing the foreign key relationships. this script is not free. the program the diagram is generated for, unfortunately, is as well not free. the evaluation versions seem to work okay, overlooking the missing functionality. if you (or anyone else) finds/has found anything better i'd be interested to know. -ravi. -Original Message- From: Eugene Mah [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 3:13 PM To: [EMAIL PROTECTED] Subject: database documentation What tools do people use to document their databases? Are there graphical tools that will generate relational diagrams of a database (like in Access)? One of the databases I've been developing is starting to grow as I add additional tables to hold different pieces of data. At the moment, my documentation comes from adding comments and CREATE statements to the result of an earlier mysqldump file. Back when I only had 7 or 8 tables, this was fine, but now my database is starting to approach 25 tables, so some of the relationships are starting to get a little hard to keep track of. Many thanks Eugene -- To put my contact info into your Palm device, click here: http://signature.coola.com/?[EMAIL PROTECTED] Personal Signature Coolet - Eugene Mah, M.Sc., DABR [EMAIL PROTECTED] Medical Physicist/Misplaced Canuck[EMAIL PROTECTED] Department of Radiology For I am a Bear of Very Little Medical University of South Carolina Brain, and long words Bother Charleston, South Carolina me. Winnie the Pooh http://home.netcom.com/~eugenem/ PGP KeyID = 0x1F9779FD, 0x319393F4 PGP keys available on request ICQ 3113529 O- - - 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 - 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
Re: database documentation
From: Ravi Raman [EMAIL PROTECTED] if you (or anyone else) finds/has found anything better i'd be interested to know. I've used Visio here and again, mostly V.6. It involves a lot of legwork since I have to manually deal with all of the lines representing relationships, but it creates a very nice output that I can export in many formats. I know that Visio Professional 5.0c can use some interesting relationship tools that handle most of the line manipulation between items. I've tried the same tools in later versions and they plainly didn't work (erred out). I've thought of getting and installing that older version just for the DB support. I've also looked at several levels of software on these download sites. Not even the pay-ware offerings looked worth having. My Dad sais that ERWin is very powerful and suggested that I buy myself a copy. Then I heard that it runs about 3K and opted not to. --- Rodney Broom Programmer: Desert.Net Spam filter: sql - 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