Was just wondering if there was any software out there to do this? The storage engine is InnoDB so the foreign keys are in place to connect the tables up in the diagram (if such software even exists).
views:
220answers:
4
+2
A:
You can generate a data model from the data table that shows foreign key constraints using Enterprise Architect.
That gives you a data model in a UML tool that you can easily trace to other UML artifacts. It does not auto-create a class model from the data tables however. It is not best practice to have your class model directly mirror your data model, but this would give you a good head start.
Eric J.
2010-03-31 22:01:27
Thanks - I'll check it out :)
Craig Whitley
2010-03-31 22:05:38
A:
Craig Whitley
2010-04-01 14:33:20
A:
Another way to do is to create a java code from the database using a project such as Dali. Once you have created the database with annotations in the code (e.g. entity for example) you can reverse it into a class diagram. You therefore get a UML model from database. The final stage is to remodel and generate again the database with hibernate for example. This is possible because the use of Java annotation mixed with the UML model. Really cool :-)
I know that Omondo is providing java annotation UML support and think some other tools should have the same feature but don't know which one.