Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 12 of 12
  1. #1
    Regular Coder
    Join Date
    Dec 2006
    Posts
    185
    Thanks
    17
    Thanked 0 Times in 0 Posts

    Relational Database Mapping Software

    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?

  • #2
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    25,602
    Thanks
    78
    Thanked 4,387 Times in 4,352 Posts
    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.
    Last edited by Old Pedant; 07-13-2011 at 04:15 AM.

  • #3
    Regular Coder
    Join Date
    Dec 2006
    Posts
    185
    Thanks
    17
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Old Pedant View Post
    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.

  • #4
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    25,602
    Thanks
    78
    Thanked 4,387 Times in 4,352 Posts
    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/Compari...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.

  • #5
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    25,602
    Thanks
    78
    Thanked 4,387 Times in 4,352 Posts
    Oh, yeah...and have you looked at MySQL Workbench? I haven't, but others like it.

  • #6
    Regular Coder
    Join Date
    Dec 2006
    Posts
    185
    Thanks
    17
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Old Pedant View Post
    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/Compari...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.

  • #7
    Rockstar Coder
    Join Date
    Jun 2002
    Location
    USA
    Posts
    9,074
    Thanks
    1
    Thanked 328 Times in 324 Posts
    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.
    OracleGuy

  • #8
    Super Moderator guelphdad's Avatar
    Join Date
    Mar 2006
    Location
    St. Catharines, Ontario Canada
    Posts
    2,634
    Thanks
    4
    Thanked 148 Times in 139 Posts
    Quote Originally Posted by thekevin07 View Post
    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.

  • #9
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    25,602
    Thanks
    78
    Thanked 4,387 Times in 4,352 Posts
    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.

  • #10
    Rockstar Coder
    Join Date
    Jun 2002
    Location
    USA
    Posts
    9,074
    Thanks
    1
    Thanked 328 Times in 324 Posts
    I have MySQL Workbench installed and I just ran it. It was pretty easy and the ER diagram is pretty good looking.
    OracleGuy

  • Users who have thanked oracleguy for this post:

    Old Pedant (07-14-2011)

  • #11
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    25,602
    Thanks
    78
    Thanked 4,387 Times in 4,352 Posts
    Thanks. I guess that's enough to convince me to download and install it. Dunno why I have kept putting it off. <grin/>

  • #12
    Super Moderator guelphdad's Avatar
    Join Date
    Mar 2006
    Location
    St. Catharines, Ontario Canada
    Posts
    2,634
    Thanks
    4
    Thanked 148 Times in 139 Posts
    Because you're old and pedantic about stuff?


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •