Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Looking for a good tool for MYSQL

 
Kim Kantola
Ranch Hand
Posts: 276
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,
I am using a mySQL database and would like to download a nice tool that could provide a visual diagram that I can print out, one that would show the tables as well as the relationships between the tables. I have downloaded something called HappyFIsh, but can't seem to figure out how to connect to the database from this app.
Anyone using a product like this that they could recommend?
Thanks!
Kim
 
Yari Podio
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Kim Kantola:
Hi All,
I am using a mySQL database and would like to download a nice tool that could provide a visual diagram that I can print out, one that would show the tables as well as the relationships between the tables. I have downloaded something called HappyFIsh, but can't seem to figure out how to connect to the database from this app.
Anyone using a product like this that they could recommend?
Thanks!
Kim


Don't know if you can do it that way (do you use WinXP?), but I always do it with Visio.

The only thing you have to do is create a ODBC bridge pointing the MySQL database, and open a Database diagram from visio, then enter the BBDD menu and choose import database, select the ODBC bridge you have created and voila.
 
Kim Kantola
Ranch Hand
Posts: 276
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you very much for your reply. I do not know how to make an ODBC bridge. Do you have an example?
 
Maximilian Xavier Stocker
Ranch Hand
Posts: 381
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I think it is of some importance to note by default MySQL does not have any foreign keys and thus there are no relationships between tables.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic