Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I'm learning DB design and looking for some tools, preferably open source software, that could help go from an ERD to a DATABASE and vice versa.

For the record, the database i'm using is MySQL.

share|improve this question

closed as off-topic by Paul White, tblPhil, RolandoMySQLDBA, bluefeet, Aaron Bertrand Jan 26 at 14:41

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – Paul White, tblPhil, RolandoMySQLDBA, bluefeet, Aaron Bertrand
If this question can be reworded to fit the rules in the help center, please edit the question.

    
Sybase's Power Designer is the tool I used, but only in ED -> DB direction. The opposite is less than satisfactory. –  dezso Nov 16 '12 at 16:27
1  
@joe A bit late to say this, but: Welcome to DBA.SE! You might notice that your original question has been slightly edited for clarity. If you haven't done so already, please read the FAQ. –  Roflo Nov 17 '12 at 1:19

3 Answers 3

Since you're using MySQL, you might want to take a look at MySQL Workbench.

It might not quite display the ERDs you're expecting but it gets the job done.

And it does have an import feature. I have only used it to import SQL files but apparently you can import from existing MySQL databases.


Also, a long time ago I found the following tools; but were not quite useful to me back then (perhaps they've matured by now):

share|improve this answer
    
cool, what i'm looking for is a designer GUI style, like Visual Studio's in which you can add entities... –  joe Nov 16 '12 at 13:08

Generate ERD with PHPMyAdmin is also a better option. PHPMyadmin added this functionality from version 3.4

detail step to generate ERD : http://goo.gl/0z3vFE

You can refer to PHPMyAdmin documentation for more info: http://www.phpmyadmin.net/documentation/#pmadb

share|improve this answer
    
When linking to your own website, you should note that in your answer, otherwise this might be considered spam. –  Max Vernon Aug 20 '14 at 14:07

I know of ERWin, though we don't use it at our company. We tend to "bleed blue" (ie, use IBM), so we use InfoSphere Data Architect.

Ideas for paid products anyway....

You could also check out IBM Data Studio as its free. I believe it does ER to DDL and it supports more than just IBM databases.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.