aspose file tools*
The moose likes JDBC and the fly likes Looking for a good tool for MYSQL Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Looking for a good tool for MYSQL" Watch "Looking for a good tool for MYSQL" New topic
Author

Looking for a good tool for MYSQL

Kim Kantola
Ranch Hand

Joined: May 17, 2001
Posts: 274
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

Joined: Feb 02, 2006
Posts: 4
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

Joined: May 17, 2001
Posts: 274
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

Joined: Sep 20, 2005
Posts: 381
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.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Looking for a good tool for MYSQL