Creating Class from sql

[Michel777]

Hi,

is it possible to generate classes based on sql script (DDL) ?

Thanks,

Michel

[qwerty]

Create a DB from the DDL and import that.

q.

[Geert Bellekens]

Or if you are really suicidal you can always try to make an SQL DDL grammar to reverse engineer into EA  

Geert

[Guillaume]

This is a good candidate for a new feature in EA. I have several DBs which cannot be that easily created on an existing DBMS to enable a reverse engineering.
It would be good to know from Sparx why such feature still doesn't exist. Having to write a script or addin doesn't seem the right way to go ; Sparx will be the most efficient to achieve this.
Afterall EA is capable of generating a SQL script/DDL, so it's hard to understand why it cannot interpret it (even if it would process only 90% of it, or so).

I'm interested in hearing from Sparx on this matter.

Thanks

[Eve]

Afterall EA is capable of generating a SQL script/DDL, so it's hard to understand why it cannot interpret it (even if it would process only 90% of it, or so).

I'm interested in hearing from Sparx on this matter.

I think that's the point. It's not hard to parse the bulk of the sql. It's harder to parse some of the syntax and map back to the appropriate UML elements. Where it becomes very hard is handling that for all the different DB variants.

Then there's the problem that 90% (or even 99%) is never really going to be good enough.

[Guillaume]

Hi Simon,

Having to install each DDL script onto an existing DB is time consuming. Hence running a reverse on the file instead of a running DB via ODBC would save time.

My understanding of the current DDL reverse in EA is that it relies on ODBC to generate data model from any DBMS. So I can understand that scripts for each DBMS could be complex. Having said that, EA does support several DBMS to generate the DDL code, so what is the difference?
It would make sense to me that a DDL file reverse support in EA would match definitions on what it is able to generate. Any other definition can be understood as ignored (to be traced in the log file).

What is the feasibility to have the above in EA?

thanks

[qwerty]

I guess the problem is that EA creates (and understands) only a subset of what is possible with DDL. So offering the ability to read it would mean to write a DDL parser/interpreter.

q.