Author Topic: Retro engineering : class/SQL schema (Read 3912 times)

Guillaume · « **on:** May 11, 2011, 05:40:20 pm »

Hi

My client sent me the DB schema i.e. all CREATE TABLE SQL scripts
I'd like to generate a DB diagram in EA from these scripts, and then generate a class diagram .

Any hint on how to do this?

thanks

Geert Bellekens · « **Reply #1 on:** May 11, 2011, 06:51:07 pm »

- Create the database using your script
- Import the database structure via ODBC into EA

Geert

Guillaume · « **Reply #2 on:** May 13, 2011, 02:31:03 am »

thanks for the info Geert

Guillaume · « **Reply #3 on:** May 23, 2011, 07:53:13 pm »

Strangely enough since EA can generate SQL scripts to create the dB tables from your db schema model, you would think that it can read SQL CREATE scripts to generate a model instead of having to create the schema in a DBMS and import via ODBC.

Unless EA9 supports this..

Geert Bellekens · « **Reply #4 on:** May 23, 2011, 08:50:10 pm »

Nope nothing like that in v9.

Geert

skiwi · « **Reply #5 on:** May 24, 2011, 12:40:27 pm »

It is a feature I'd like, and I think should be there.
Vote.
Please submit it as a feature request.

Guillaume · « **Reply #6 on:** May 24, 2011, 04:18:47 pm »

already done yesterday

Sparx Systems Forum

News: