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

[Bill Karwin]

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

[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

[Leif]

"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

[Vaclav Frolik]

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