Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: Guillaume on June 28, 2013, 07:49:17 pm

Title: How to import DDL from an SQL dump
Post by: Guillaume on June 28, 2013, 07:49:17 pm

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

Title: Re: How to import DDL from an SQL dump
Post by: Geert Bellekens on June 28, 2013, 08:08:19 pm

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

Geert

Title: Re: How to import DDL from an SQL dump
Post by: Guillaume on June 29, 2013, 03:12:07 am

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!

Title: Re: How to import DDL from an SQL dump
Post by: g.makulik on June 29, 2013, 04:10:18 am

Quote

-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

Title: Re: How to import DDL from an SQL dump
Post by: skiwi on November 20, 2018, 08:58:56 am

Quote from: Guillaume on June 28, 2013, 07:49:17 pm

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)

Title: Re: How to import DDL from an SQL dump
Post by: skiwi on January 09, 2023, 12:12:17 pm

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