Automated UML2 Class Diagram generation from SQL? How can I generate a class diagram from an SQL database or script?  I'll add the functions and set whether the attributes are public, private or virtual once the initial diagram is generated.

I've generated it using PowerDesigner, here is the .sql file: http://pastebin.com/S14JWjKF
Solution:


Generate SQL file in PowerDesigner (or any other tool capable of
generating SQL, or write it by hand)
Install Eclipse with JPA and Modelling Tools
Follow this guide
When the guide fails you (step 4), open up another tool (or you
could probably do it in Eclipse with a new project), for instance,
PowerDesigner; and reverse-engineer the Java code into a Class
diagram
Profit!


:D