Reverse DDL to ERD models
| Written Date: May 12, 2007 | ||||
User Rating:
/ 0
|
Hits: 2,677 |
|
||
A DDL (Data Definition Language) file is a computer language for defining data. Now, you can also use it to generate ERD models like entities, views and relationships by reversing the DDL.
Reversing DDL
| 1. | Here shows an extraction of the DDL file for MySQL database that we are going to reverse. |
 |
|
| 2. | To reverse DDL, select menu Tools > Reverse DDL.... |
 |
|
| 3. | In the Reverse DDL dialog box, type the path of DDL file in File path, and select the target database of this DDL in the Database list. |
 |
|
| 4. | After reversing, the models like entities, columns and relationships are generated according to the DDL. |
 |
|
| 5. | You can select interested models in Model pane, right-click on them and select Form ER Diagram from the popup menu to generate an ERD. |
 |
|
Resources
| • Know more about Visual Paradigm for UML — A powerful visual UML CASE tool. | |
| http://www.visual-paradigm.com/product/vpuml/ | |
| • Look at the features of Visual Paradigm for UML | |
| http://www.visual-paradigm.com/product/vpuml/features/ | |
| • Get the Free 30 Days Trial of Visual Paradigm for UML | |
| http://www.visual-paradigm.com/product/vpuml/vpumldownload.jsp | |
| • Learn more on visual modeling feature from Visual Paradigm for UML's online documentation | |
| http://www.visual-paradigm.com/product/vpuml/vpumluserguide.jsp | |
| • View Visual Paradigm for UML's Interactive Tutorials | |
| http://www.visual-paradigm.com/product/vpuml/tutorials/ | |
| • Screenshot of Visual Paradigm for UML | |
| http://www.visual-paradigm.com/product/vpuml/vpumlscreenshots.jsp | |
| • Know more about Visual Paradigm Suite 3.0 SP2 | |
| http://oldresources.visual-paradigm.com/vpsuite3.0sp2/ | |
Rate this Article
Click on one of the stars below to rate this article from 1 (lowest) to 5 (highest).
Comments (3)
written by a on May 25, 2011
VP has bugs hahaha
written by Jick Yeung on May 25, 2011
Dear a,
Thank you for your post and sorry for any inconvenience the problem might have caused. Could you tell me what the bug is? We would like to fix it up.
written by Queenie on December 16, 2011
Now I feel sputid. That's cleared it up for me