Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Open source ER diagramming tool for mysql

Tags:

mysql

reverse-engineering

erd

I want to reverse engineer (import into diagram form) the database definition dump of a database I have, then since no foreign keys are defined in this particular database, I want to be able to manually create the table to table key mappings (using crow feet notation if possible).

I've taken a look at MySQL Workbench, and it gets me 85% of the way there. The nice little relationship lines won't show up though, and the auto arrange is horrible. A quick search of google turns up several other options, so I can evaluate these on my own, but:

Can I get some feedback from you guys for which are your favorite tools to use for this scenario? Why do you like that(your) particular tool?

My intended purpose is to take a legacy database, and train jr. engineers on the organization of the DB. Visual aids are nifty. My fallback option is to recreate an ER diagram by hand. Not fun for 250+ tables.

like image 545
Zak Avatar asked Nov 12 '08 23:11

Zak

People also ask

Can we make ER diagram in MySQL?

While the community edition of MySQL Workbench does not include a simple feature for creating Entity Relationship diagrams, there is a way to do it. Tushar Soam documented it in Create ER Diagram of a Database in MySQL Workbench and it worked fine for me.

How do you create a diagram in MySQL?

Open MySQL Workbench. Select File and New Model from the top menu. Select File, hover over Import, and press Reverse Engineer MySQL Create Script…. Specify the SQL file needing a diagram. Press Execute, Next, and then Finish.

1 Answers

You might check out DBDesigner ...

Now known as MySQL Workbench

http://dev.mysql.com/downloads/workbench/5.0.html

like image 89
dkretz Avatar answered Oct 16 '22 05:10

dkretz
Sign in to Comment

Related questions

How to call a stored procedure in CodeIgniter?
MySQL Generate Random Data
Packets out of order error when calling MySQL stored proc
Select, count and where using codeigniter and mysql
SQL Statement - SELECT the inverse of this query
What's the purpose of varchar(0)
Liquibase tried to apply all changeset, even if database is present
Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: INSERT INTO
Difference in mysql dump file size and database size
Entity Framework Code First MaxLength and FixedLegth (char vs varchar)
Can't insert new records through PHP into mysql database
Mysqldump without triggers
How to add reference to assembly in visual studio mac?
Index for ENUM datatypes
How do I avoid 'port collision' when using docker?
OSX ld: library not found for -lssl
phpmyadmin shows Error in processing request popup
Disabling MySQL Strict Mode only for one query Laravel 5.6
Setting up PHP-FPM, Nginx, Mariadb on CentOs using docker
How to get insert id after save to database in CodeIgniter 4

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!