EA Newbie - Database schema

[Sonya]

I recently purchased EA and I am still trying to feel my way around. I imported a database schema from SQL and would like to find out the different ways to analyze the data I imported.

Also can EA automatically generate diagrams from the downloaded schema? If there is an article I can read on these kinds of things, I will also appreciate this.

[«Midnight»]

EA can generate data model diagrams. You can use transformations to create class diagrams from there. [I do not remember if any basic database-to-class transformations are included in the EA installation.]

Check the EA help for the options on the database schema import dialog. That's where you tell EA to create diagrams.

[salayande]

I am trying to write a transform that will convert a database schema to class diagram. My challenges include the different acronyms (undocumented), multiple naming standards used by various vendors etc. Little or no metadata. The transformation macros do not support the definition of arrays which makes the task almost impossible. I am investigating VBScipt, but it might take a while to learn before I can do anything useful with it.