A while back I needed a tool to transform big relational database schemas to UML2 models. There is Andromda's Schema2XMI which I used a few times in my early MDSD experiences, but the output is UML1.X XMI for Magic Draw. If I am using UML as modeling technolgy nowadays, I want to use EMF-based UML2 implementation for better handling in an independent MDSD environment. It is possible to update 1.X models with a special version of Magic Draw to UML2 and export them to EMF-UML2. But that all is not really pleasant and often I needed some extra requirements for this kind of transformations. That's why I wrote schema2uml hosted on google code (http://code.google.com/p/schema2uml).

Schema2UML transforms relational database schemas into EMF-UML2 models. Tables are mapped to classes with appropriate class and attribute name conversions. Foreign keys are mapped to associations with appropriate role name conversions, cardinalities and types. If there is a cascade delete rule on the foreign key the association type will be composite. Using an uml profile there is collected more data like table and column names, primary keys, database types, jdbc types, precision, scale ...

Composite foreign keys are not supported yet.

Check out the eclipse project from the source code repository. Simply install EMF and UML2 over your eclipse release update site. Rename schema2uml.properties.default to schema2uml.properties and configure it. There is a default uml2 profile included. Configure the mappings.xml and rules.xml files and run Schema2UML.