Which Tool can generate UML by SQL?

Question

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.

Answer 1

SQL Diagrams

Answer 2

PowerDesigner by Sybase allows you reverse DB from script (so called Physical model) and after all convert it to another diagram including UML object model

Answer 3

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

Answer 4

A trick is to generate a java code from your database then to reverse the code within an UML tool. A good Eclipse project is Dali which can generate an annoted code (e.g. @Entity) in your code.

Answer 5

Hi Sarfraz,

The SQL diagram tool is not an UML tool but a database modeler !! UML requires object mapping with relational database.

Answer 6

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.

Answer 7

If you have a IBM rational rose software is not freeware but this is the best software engineering tools for UML to SQL database. It does so many interesting things so try to work on IBM rational rose.

That you can download from Download - Rational Rose