Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Get UML diagram from relational database [closed]

Tags:

postgresql

uml

I use PostegresQL 9. Is there a free tool to derive UML diagrams from my databases?

Thanks

like image 480
Martin Preusse Avatar asked Nov 12 '10 15:11

Martin Preusse


People also ask

How do I export a diagram from SQL Server?

Export SQL relationship diagram To export a diagram to an image, follow these steps: Right-click the diagram and select Export to Image from the shortcut menu. Specify the target file name and image format. Click the Save button.

Can we generate ER diagram from database?

You can also import your own database to streamline ERD creation. LucidChart has plenty of collaboration options so you can work on the diagram with your teammates collectively (with features like sticky notes, comments, and mentions).

How do you convert class diagram to ERD?

Convert ER diagram to Class diagramSelect [Convert to Class Diagram] from ER Diagram's pop-up menu in the structure tree. The diagram and all the model elements inside will be converted to a Class diagram and appears in the tree view.


3 Answers

For creating ER diagrams by db reflection, I use: DbVisualizer

http://www.dbvis.com/

It's free.

like image 198
vonPetrushev Avatar answered Oct 14 '22 10:10

vonPetrushev


There's also postgresql_autodoc which can create GraphViz or Dia output. The diagrams will likely require further tweaking, though.

like image 30
gorthx Avatar answered Oct 14 '22 10:10

gorthx


There's a free tool called Dia and a plugin called PostDia. They would do it for you.

Plus:

  1. it generates postegres sql scheme files too
  2. Both are free.

Requirements for PostDia: python and psycopg2, to install the second one:

pip install psycopg2

like image 1
FabricioFCarv Avatar answered Oct 14 '22 10:10

FabricioFCarv