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.

Solution 1

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

Solution 2

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.