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.
- 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