Author Topic: How to import DDL from an SQL dump  (Read 14900 times)

Guillaume

  • EA Practitioner
  • ***
  • Posts: 1309
  • Karma: +42/-2
    • View Profile
    • www.umlchannel.com
How to import DDL from an SQL dump
« 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
Guillaume

Blog: www.umlchannel.com | Free utilities addin: www.eautils.com


Geert Bellekens

  • EA Guru
  • *****
  • Posts: 12853
  • Karma: +535/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: How to import DDL from an SQL dump
« Reply #1 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

Guillaume

  • EA Practitioner
  • ***
  • Posts: 1309
  • Karma: +42/-2
    • View Profile
    • www.umlchannel.com
Re: How to import DDL from an SQL dump
« Reply #2 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!
Guillaume

Blog: www.umlchannel.com | Free utilities addin: www.eautils.com


g.makulik

  • EA User
  • **
  • Posts: 355
  • Karma: +0/-0
    • View Profile
Re: How to import DDL from an SQL dump
« Reply #3 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
Using EA9.3, UML2.3, C++, linux, my brain, http://makulik.github.com/sttcl/

skiwi

  • EA Expert
  • ****
  • Posts: 2045
  • Karma: +46/-82
    • View Profile
Re: How to import DDL from an SQL dump
« Reply #4 on: November 20, 2018, 08:58:56 am »
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)
Orthogonality rules
Using EA16.1 (1627) on Windows 11 Enterprise/64 bit. Repositories in SQLServer2019 DB Schema 1558.
WebEA on Pro Cloud Server 4.2.64

skiwi

  • EA Expert
  • ****
  • Posts: 2045
  • Karma: +46/-82
    • View Profile
Re: How to import DDL from an SQL dump
« Reply #5 on: January 09, 2023, 12:12:17 pm »
Still wishing this (import from .SPL schema export) was a thing ...
Orthogonality rules
Using EA16.1 (1627) on Windows 11 Enterprise/64 bit. Repositories in SQLServer2019 DB Schema 1558.
WebEA on Pro Cloud Server 4.2.64