30

i want tool for to generate DB diagram below, i need to generate particular db tables structure like below,

enter image description here

how can i do that?...is there any free tool or application is available for that. i already tried navicat8lite_ora_en and HeidiSQL. but i can't make it work.

Ravichandran Jothi
  • 3,028
  • 11
  • 52
  • 82
  • 2
    and also a dupe of http://stackoverflow.com/questions/285828/open-source-er-diagramming-tool-for-mysql which is a better choice. – fvu Jun 28 '12 at 14:17

3 Answers3

48

Yes you can generate ERD with PHPMyAdmin. PHPMyadmin added this functionality from version 3.4

detail step to generate ERD: http://sforsuresh.in/generating-erd-using-phpmyadmin/

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

Cœur
  • 37,241
  • 25
  • 195
  • 267
Suresh Kamrushi
  • 15,627
  • 13
  • 75
  • 90
  • 5
    I don't know , why this post is not marked as answer while i gives the 100% precise answer . Great job – Mani Oct 07 '15 at 11:49
  • @ImranNaqvi My guess is that the OP accepted an answer long before this was posted. Also, a reader would prefer detailed answer instead of links only answer just in case the referenced webpages go down in future.. – Fr0zenFyr Mar 29 '16 at 07:59
  • 1
    There's a problem when you have too many tables, it gets overlapping. Anyone knows how to solve it? – Marcelo Agimóvel May 18 '18 at 12:47
25

MySQL Workbench will reverse engineer and engineer scripts for you. Output will be similar to what you have above, but not identical.

Steven Scott
  • 10,234
  • 9
  • 69
  • 117
  • 1
    actually i tried above one. but i could not connect. i don't know whats the problem. – Ravichandran Jothi Jun 29 '12 at 05:28
  • 1
    What error did you receive? The MySQL Workbench will need to link to an active database to read from (if not using the SQL definition) and therefore, you would need the connection information (user name, password, etc...). – Steven Scott Jul 03 '12 at 15:10
0

Try Vertabelo. It's an online database modeler working under Chrome. It is:

  • free to use,
  • OS independent,
  • allows versioning,
  • supports model validation,
  • generates SQL scripts for particular database:
  • allows sharing your DB model with other members of your team,
  • allows reverse engineering - so you can easily migrate your database to Vertabelo,
  • suports following databases:
    • PostgreSQL,
    • MySQL,
    • Oracle,
    • IBM DB2,
    • HSQLDB,
    • MS SQL Server.
Bartek
  • 277
  • 2
  • 4