开发者

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

开发者 https://www.devze.com 2023-01-05 19:06 出处:网络
I have my database built already, but I really wa开发者_如何转开发nt 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 co

I have my database built already, but I really wa开发者_如何转开发nt 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


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


MySQL Workbench should be able to do this.

0

精彩评论

暂无评论...
验证码 换一张
取 消