How to import DDL from an SQL dump

[Guillaume]

Hi,

EA lets you import a DB schema via an ODBC connexion. It also lets you generate into a file the scripts to generate the schema from a model.

I have an SQL dump that I need to import into EA (no access to the DBMS) and it looks to me that EA should be able to do that, however this feature seems to be hidden somewhere.

Any idea on achieving this?

thanks

[Geert Bellekens]

You can't.
The only solution is to create the database structure somewhere (using the SQL dump) and then use the ODBC import.

Geert

[Guillaume]

It's a shame - I think there's room for a couple of improvements there :
-making it possible to run a reverse from a DDL SQL file (after all running a reverse on what EA has generated sounds logical)
-giving access to the code template that generates the SQL for each DBMS (mysql, sql server and so on) so we can tweak as needed

Cheers!

[g.makulik]

-making it possible to run a reverse from a DDL SQL file (after all running a reverse on what EA has generated sounds logical)

In principle this feature is available since EA 10.x. You may provide an SQL DDL dialect extension language AST to parse directly from SQL command batch files and create an UML model for these.

Look here: http://www.sparxsystems.com/enterprise_architect_user_guide/10/extending_uml_models/grammar_editor_for_imported_co.html

HTH
Günther

[skiwi]

Hi,

EA lets you import a DB schema via an ODBC connexion. It also lets you generate into a file the scripts to generate the schema from a model.

I have an SQL dump that I need to import into EA (no access to the DBMS) and it looks to me that EA should be able to do that, however this feature seems to be hidden somewhere.

Any idea on achieving this?

thanks

Gosh, bump (import schema from DDL)

[skiwi]

Still wishing this (import from .SPL schema export) was a thing ...