Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Anyone know of a decent free DB schema reverse engineering tool? [closed]

Looking for a tool that will automatically create a graphical representation of a MySQL DB schema from a live database, showing tables, columns, and relationships (an ER diagram). Ideally something that would run on OS X would be great but I'll take what I can get and run it on a different machine if necessary.

I checked Google and del.icio.us. Seems most products that do this are commercial. I guess they're expensive to develop?

MySQL has the Workbench but it costs extra for the reverse engineering features.

This open source tool SchemaSpy looks kind of promising, but maybe a little awkward to install and use. Before I dive into that, I thought I'd check whether anyone knows of something more "instant gratification."

like image 870
Ethan Avatar asked Jan 03 '09 02:01

Ethan


People also ask

How do you reverse engineer a database schema?

To reverse engineer database go to menu Database and choose Reverse Engineer... option. Provide connection details to your database and click Next. Wait for the connection and click Next again.


1 Answers

Check out SQuirreL.

You need to right click the table and choose the option, 'Add to Graph'. Then it will open a new tab. After switching to that tab you will see the table represented in a box. Just right click the box and select 'Add all children', and 'Add all Parent'. It will include the complete hierarchy, with the Entity, and Relationships. So, you can say it would generate an ERD.

Hope this would help.

like image 57
Adeel Ansari Avatar answered Sep 22 '22 00:09

Adeel Ansari