469,935 Members | 1,480 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,935 developers. It's quick & easy.

Document a mySql database

Ian
Hi there,

Maybe this is a strange quesiton but maybe someone can advise.

I have created a database and it is getting larger and larger, I wonder if
there any tools when you can actually document the database i.e. create
database maps and see all the joins and what field has what type, and what
comments assigned.

Basically so later if I decide to go to it, I can check a kind of database
documentation and know exactly what refers to what.

Does anything exist like this? If so what applicaiton can I use to produce
such a thing and read it too

Thanks in advance for any comments

Ian
Jul 20 '05 #1
4 1501
Search for "ER diagram" tools. "ER" in this context means "entity
relationship." These are software applications with which you can
design a graphical diagram for a database schema. Some of these even do
"reverse engineering" and produce a diagram from an existing database.

There are quite a few such products on the market. For example, here's
a query that shows a few in MySQL AB's catalog of 3rd party products for
MySQL:

http://solutions.mysql.com/search.ph...t=92&q=diagram

In a pinch I have also used Microsoft Office to design diagrams by hand.
In PowerPoint, you can place boxes and connect them with "rubber band"
lines that stretch as you move the boxes around. But this is laborious
to maintain, and has no integration with your database.

Regards,
Bill K.

Ian wrote:
Hi there,

Maybe this is a strange quesiton but maybe someone can advise.

I have created a database and it is getting larger and larger, I wonder if
there any tools when you can actually document the database i.e. create
database maps and see all the joins and what field has what type, and what
comments assigned.

Basically so later if I decide to go to it, I can check a kind of database
documentation and know exactly what refers to what.

Does anything exist like this? If so what applicaiton can I use to produce
such a thing and read it too

Thanks in advance for any comments

Ian


Jul 20 '05 #2
Ian
Wow thanks..

Thats just what I needed, much appreciated..

I am looking at dezign for databases currently, it looks very powerful.

Thanks again

Ian
"Bill Karwin" <bi**@karwin.com> wrote in message
news:cb********@enews3.newsguy.com...
Search for "ER diagram" tools. "ER" in this context means "entity
relationship." These are software applications with which you can
design a graphical diagram for a database schema. Some of these even do
"reverse engineering" and produce a diagram from an existing database.

There are quite a few such products on the market. For example, here's
a query that shows a few in MySQL AB's catalog of 3rd party products for
MySQL:

http://solutions.mysql.com/search.ph...t=92&q=diagram

In a pinch I have also used Microsoft Office to design diagrams by hand.
In PowerPoint, you can place boxes and connect them with "rubber band"
lines that stretch as you move the boxes around. But this is laborious
to maintain, and has no integration with your database.

Regards,
Bill K.

Ian wrote:
Hi there,

Maybe this is a strange quesiton but maybe someone can advise.

I have created a database and it is getting larger and larger, I wonder if there any tools when you can actually document the database i.e. create
database maps and see all the joins and what field has what type, and what comments assigned.

Basically so later if I decide to go to it, I can check a kind of database documentation and know exactly what refers to what.

Does anything exist like this? If so what applicaiton can I use to produce such a thing and read it too

Thanks in advance for any comments

Ian

Jul 20 '05 #3

"Ian" <ia*********@hotmail.com> skrev i en meddelelse
news:%d***********************@news.easynews.com.. .
Hi there,

Maybe this is a strange quesiton but maybe someone can advise.

I have created a database and it is getting larger and larger, I wonder if
there any tools when you can actually document the database i.e. create
database maps and see all the joins and what field has what type, and what
comments assigned.


phpmyadmin can do that, and produce the output as pdf.

Leif
Jul 20 '05 #4
Hi Ian,

please feel free to try our CASE Studio 2.

http://www.casestudio.com

It allows you to generate very detailed report of your MySQL database.
You can generate RTF as well as HTML report. Moreover, you can affect
the generation via the internal Templates Editor.

Regards,

Vaclav Frolik
CHARONWARE
Jul 20 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Dave White | last post: by
8 posts views Thread by Sandy Norton | last post: by
51 posts views Thread by w_curtis | last post: by
reply views Thread by Ben Holness | last post: by
Atli
6 posts views Thread by Atli | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.