CODEWITHSUNDEEP
sqlmysql
Brandon G
Brandon G

Reputation: 2893

Utility to create an ERD from an already existing MySQL DB?

I have my database built already, but I really want to print out an erd to reference while I'm building my models. Is there a utility that can generate an erd from a SQL dump or by connecting to the database directly?

Thanks in advance,

~Brandon

Upvotes: 2

Views: 3173

Answers (2)

Chris Hutchinson
Chris Hutchinson

Reputation: 9212

The Data Modelling component of MySQL Workbench 5.2 OSS can do what you are describing, depending on the ERD notation you are seeking.

From the Home tab, select Create EER Model from Existing Database, then simply follow the wizard that displays. It will you run you through connecting to an RDBMS, choosing the objects to model, and then create the model for you.

If you're looking for traditional Chen or Crow's Foot notation, make sure you select Classic in the Model > Object Notation menu, and Crow's Foot in the Model > Relationship Notation menu.

MySQL Workbench

Upvotes: 3

roufamatic
roufamatic

Reputation: 18495

MySQL Workbench should be able to do this.

Upvotes: 2

Related Questions