Database Tables

[frankk]

I have a database schema mapped out as a Class diagram. I just noticed that EA supports actual Table elements, with 'column' (etc.) attributes.

Is there any way to convert a Class to a Table? Or would I have to redraw all the diagrams?

[«Midnight»]

Hi Frank,

There may be a built-in transform to do this. If not, it should not be too difficult to create one.

Just make sure you have your default database set in the Settings | Database Datatypes dialog first.

David

[dbax]

No need to write special transformation. Just use the EA's built in transformation and transform the class package to DDL. Then you will get the classes stereotyped as tables with Language property list showing EA's supported target databases. You will need to set each table to desired DBMS.

[«Midnight»]

Thanks,

I seem to find myself transforming the other way, so I'd forgotten how best to do this in EA. I was just sure there was a way.

David

[frankk]

Sorry, I've never done a transformation. Could someone please point me at the appropriate documentation?

What do I do after transforming to DDL?

[thomaskilian]

See the Help.

[RoyC]

This gives you the introduction to Transforms:

http://www.sparxsystems.com.au/EAUserGuide/index.html?mdastyletransforms.htm

This tells you about the built-in DDL Transformation:

http://www.sparxsystems.com.au/EAUserGuide/index.html?ddltransformation.htm

And if that does not give you what you want, this tells you about writing your own transformations:

http://www.sparxsystems.com.au/EAUserGuide/index.html?writingtransformations.htm

HTH

[frankk]

Thank you :-)