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.
精彩评论