Import SQL Schema

[Edward Stow]

Hi,

I would like to import a schema defined using SQL DDL.

Is this possible?

Using EA Professional
--
Edward

[hd]

If you mean importing from a DDL script file - no that is not possible.

However, you can import database schemas through ODBC - refer...
http://www.sparxsystems.com/uml_tool_guide/data_modeling/importdatabaseschemafromod.html

[Edward Stow]

If you mean importing from a DDL script file - no that is not possible.

Yes thats what I meant ... pity .. I am working from some legacy application source code that needs re-engineering, but however it is not an installed system.

[salayande]

Surely if EA can read and parse XML Schema files and create a physical design model, I cannot see why it should not be able to read DDL scripts and create relational design models.

Sparxsystems should consider this query as a product improvement opportunity.


Segun

[Edward Stow]

I can see it would not be that easy to import from a variety of SQL Dialects (compare MySQL with Oracle for example) but it would be a nice feature.
--
Edward