How to generate ERD or UML for a database?

Question

Link to the previous question , it is not possible to easily generate UML or ERD . How can this be done? Even the details that describe fudforum.*; will do the trick, except that you cannot use a wildcard.

Something like mysqldump -d -u <username> -p<password> -h <hostname> <dbname> , but more readable?

It seems devart does not work on Linux, but I'm learning this.

MySQL:

 mysql> mysql> describe fudforum.fud30_xmlagg; +----------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+--------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | name | varchar(255) | NO | | | | | url | varchar(255) | NO | | | | | forum_id | int(11) | NO | MUL | 0 | | | xmlagg_opt | int(11) | NO | | 2 | | | last_load_date | bigint(20) | NO | | 0 | | | custom_sig | text | YES | | NULL | | +----------------+--------------+------+-----+---------+----------------+ 7 rows in set (0.04 sec) mysql> mysql> quit; Bye thufir@dur :~$ 

Answer 1

mysql workbench can reverse engineer and create erd

http://www.mysql.com/products/workbench/

Answer 2

There is a tutorial on converting Oracle 10G to UML using the Eclipse and Dali plugins.

You can simply exchange Oracle using your database sql connector inside Dali, and it will do the job.

Answer 3

Mysqlshow command:

  mysqlshow fudforum 

Answer 4

I tried many times to get MySQL Workbench to automatically generate ERDs with relationship lines, but always left disappointment. Most of the databases I worked with used MyISAM tables without specific foreign keys. This seemed to stop Workbench from generating the relationships I wanted, or I just couldn't figure out how to make it work. I also tried many other solutions, but again did not find a convenient solution that I was looking for until I came across this blog post on mysqlworkbench.org.

MySQL Workbench Plugin: automatic creation of foreign keys

The post is a complete explanation of how to force Workbench to search all your tables for candidate foreign keys in other tables. It even shows how to get a working graphical interface for it. Best of all, the article refers to a Python script that can be installed in Workbench as a plugin so that you can handle everything for you.

After installing the plugin, you launch it and give it a template that will be used to check the correspondence of the keys. He then gives you a list of keys that he considers matching, which you can choose if you agree. Then you press the button and generate an ERD for you with all the relationship lines. Hallelujah!

Many thanks to akojima at MySQL Workbench. Now, if I could take Delorean for another four years and find it when it was published in 2010.