Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Which Tool can generate UML by SQL? [closed]

Tags:

sql

uml

diagram

I'm searching a tool for generating UML-Diagrams by the import of SQL-Syntax-Files.

I need it for personal usage. Best if it's free or if there is a free trial license available.

like image 603
Haiperlink Avatar asked Feb 20 '10 12:02

Haiperlink


People also ask

Which tool is used for UML diagrams?

StarUML is a tool specifically used for drawing UML diagrams. It is a diagramming tool mainly used for agile and concise modeling. It also uses source codes of programming languages and converts that into models.

What is UML in SQL?

Unified Modeling Language (UML) plays a big role in software development, but also in non-software systems throughout many industries, as it's a way to visually show the behavior and structure of a system or a process.

Can UML tool generate code?

UML diagrams are used to diagrammatically model and specify the static structure as well as the dynamic behavior of object-oriented systems and the software tools then go ahead and automatically produce code from the given diagrams.

Which tool is most useful to create a UML use case diagram?

You can create a UML use case diagram in Visio to summarize how users (or actors) interact with a system, such as a software application.


2 Answers

SQL-Syntax is provided by

  • Data Manipulation Language (DML) select,insert,update..
  • Data Definition Language (DDL) create table,..
  • Data Control Language (DCL) grant,revoke

The closest thing you can map to UML are tables to classes (DDL).

Visual Paradigm among other UML tools offers reverse engineering of existing database schema

like image 53
stacker Avatar answered Sep 27 '22 22:09

stacker


If you just need database structure diagrams (entity relationship diagrams), Visio has a nice way to connect to a database and generate an ERD from the schema. If you are looking for a class diagram, you can use Visual Studio 2010 to create entity framework objects from a database and will give you a few different ways to represent them (either in the entity framework GUI designer, or by creating a class diagram from the generated classes.

like image 21
BrianCumminger Avatar answered Sep 27 '22 22:09

BrianCumminger