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
    
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

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

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 at 14:07

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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