...

View Full Version : Relational Database Mapping Software



thekevin07
07-13-2011, 03:35 AM
I have a rather large database with hundreds of tables that I now have to map out in a diagram. I was wondering if there was a way I could import my database into a software program that could map out how each table relates to one another.

I know there is software to build a relational diagram for a database but is there one that will generate a diagram for a database that already exists?

Old Pedant
07-13-2011, 03:59 AM
http://www.lmgtfy.com/?q=database+mapping+software

Though you might get better results with "data modeling" or some other phrases.

There are tons of products on the market. The trick is finding the one that meets your specific needs.

thekevin07
07-13-2011, 04:17 AM
http://www.lmgtfy.com/?q=database+mapping+software

I don't need smart *** answers! I searched Google already.

I'm looking for software recommendations/suggestions from people that have actually used the software and are happy or at least have heard good things or people telling me what software I should stay away from.

UPDATE: Old Pendant just posted a link when I wrote the above.

Old Pedant
07-13-2011, 04:55 AM
Okay, so you might have said that to begin with.

I've used a couple of tools in the past, but they were just whatever the company I was working for at the time had on hand. Even worked for one company that tried to produce such a tool. Not surprisingly, they aren't around any more.

Have you seen this, at least:
http://en.wikipedia.org/wiki/Comparison_of_data_modeling_tools

Ahh...there is one in there that I have used:
http://gnuwin.epfl.ch/apps/DDT/en/
Not too powerful, but it might do what you want. Can't tell.

And I *believe* we used this tool a couple of jobs back:
http://www.datanamic.com/dezign/index.html
name rings a bell, but I wasn't actively using it...only looking at diagrams produced.

Old Pedant
07-13-2011, 05:01 AM
Oh, yeah...and have you looked at MySQL Workbench? I haven't, but others like it.

thekevin07
07-13-2011, 05:24 AM
Okay, so you might have said that to begin with.

I've used a couple of tools in the past, but they were just whatever the company I was working for at the time had on hand. Even worked for one company that tried to produce such a tool. Not surprisingly, they aren't around any more.

Have you seen this, at least:
http://en.wikipedia.org/wiki/Comparison_of_data_modeling_tools

Ahh...there is one in there that I have used:
http://gnuwin.epfl.ch/apps/DDT/en/
Not too powerful, but it might do what you want. Can't tell.

And I *believe* we used this tool a couple of jobs back:
http://www.datanamic.com/dezign/index.html
name rings a bell, but I wasn't actively using it...only looking at diagrams produced.

Sorry for the name calling but I would have thought that already searching google for a subject would be implied especially on this forum.

Thank you for the links +rep

Anyone else have any other reviews, suggestions etc.

oracleguy
07-13-2011, 06:31 AM
Microsoft Visio can do it too but you need the Professional Edition or whatever the middle edition is or higher. The base version doesn't support ER diagrams. I haven't tried it with MySQL specifically but I've done it with other database systems but it probably works since it lets you use whatever drivers you have installed.

guelphdad
07-13-2011, 04:00 PM
I would have thought that already searching google for a subject would be implied especially on this forum.


nope, can't take anything for granted. I moderate a number of sites and folks ask the same questions over and over again so know they don't search the sites they post on. So assuming they've done a google search on top of that isn't something I (or others) are willing to do.

Can understand your frustration, thank you too for taking the time to apologize to Old Pedant.

Old Pedant
07-13-2011, 10:08 PM
Yeah, I used Visio when I worked at MicroSlop, but only with SQL Server so wasn't sure if it could handle MySQL or not else would have mentioned it. But now that you mention it, OracleGuy, I think it probably could.

Has anybody tried MySQL Workbench to see if it can do it?? Almost tempted to install it just to see.

oracleguy
07-13-2011, 10:45 PM
I have MySQL Workbench installed and I just ran it. It was pretty easy and the ER diagram is pretty good looking.

Old Pedant
07-14-2011, 12:19 AM
Thanks. I guess that's enough to convince me to download and install it. Dunno why I have kept putting it off. <grin/>

guelphdad
07-14-2011, 05:42 PM
Because you're old and pedantic about stuff? :)



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum