Author Topic: Oracle Reverse Engineer (Read 11189 times)

Geert Bellekens · « **Reply #15 on:** May 30, 2018, 06:28:40 pm »

We discussed that in the past.

The advantage of using ODBC is that it gets you a standardized interface for any database (given the ODBC driver is implemented correctly).
So in this case EA doesn't have to worry about the actual database type, as long as it conforms to the ODBC standard it can be imported.

Now in theory that should also work for importing DDL,'s since SQL is in fact an ANSI standard.
Unfortunately that doesn't work in the real world as each database vendor has invented his own SQL dialect.

So if EA was to implement such a feature it should cater for each and every different SQL dialect out there.

I too would like a DDL import feature, but I can understand why Sparx choose the ODBC option. I would probably do the same if I was in their shoes.

Geert

PS. For a client who needed to RE a DB2 database from the mainframe we have build our own DDL parser to correct the part that was imported via ODBC

Richard Freggi · « **Reply #16 on:** May 30, 2018, 06:34:07 pm »

Quote from: qwerty on May 30, 2018, 05:27:29 pm

Yes, I know that EA can't RE a DDL. Unfortunately there's no emphasis for irony/sarcasm in texts.

q.

I didn't know that! Not even the higher cost versions? Don't open source tools like MySQLWorkbench do that already? Me sees a feature request lurking somewhere......

qwerty · « **Reply #17 on:** May 30, 2018, 06:40:59 pm »

EA can' parse DDL. Since it internally seems to have a SQL parser (the SQL you send from EA to a DB are mangled in the one or other way) there should be ways to get EA eating a DDL. However, times for seeing feature requests being implemented are no longer in the range of a couple of weeks.

q.

Glassboy · « **Reply #18 on:** May 31, 2018, 09:53:20 am »

Quote from: qwerty on May 30, 2018, 06:40:59 pm

EA can' parse DDL. Since it internally seems to have a SQL parser (the SQL you send from EA to a DB are mangled in the one or other way) there should be ways to get EA eating a DDL. However, times for seeing feature requests being implemented are no longer in the range of a couple of weeks.

I think that this sort of functionality would be best community produced. Sparx should be responsible for the parser and documentation about it and the community could craft for the particular database technology.

Eve · « **Reply #19 on:** May 31, 2018, 10:18:01 am »

Yes qwerty, I understood your sarcasm. Unfortunately, not everyone in the thread seemed to realise.

qwerty · « **Reply #20 on:** May 31, 2018, 05:21:07 pm »

Doh

q.

Sunshine · « **Reply #21 on:** June 02, 2018, 11:33:04 am »

Quote from: qwerty on May 30, 2018, 05:27:29 pm

Yes, I know that EA can't RE a DDL. Unfortunately there's no emphasis for irony/sarcasm in texts.

q.

Mmmh really? No smiley or emojicon then for sarcasm

qwerty · « **Reply #22 on:** June 02, 2018, 10:10:59 pm »

Actually I can't interpret any of them as "sarcastic intention".

is shocked (as you can also read from the hovered note).

q.

Sparx Systems Forum

News: