Book a Demo

Author Topic: Oracle comments from model notes  (Read 3470 times)

karu

  • EA Novice
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
Oracle comments from model notes
« on: May 03, 2012, 12:04:50 pm »
Hi,

We generate an Oracle schema (DDL) out of our EA 9.1 model.

We would also like to store table and column comments/notes in the model and then export them as a set of Oracle 'comment on table' and 'comment on column' statements.

Is there a built in feature that I am missing?

The only thing I can think of is to export to xml and then parse the xml and write a script - is there a better way?

Thanks,

David

hd

  • EA Administrator
  • EA User
  • *****
  • Posts: 312
  • Karma: +0/-0
    • View Profile
Re: Oracle comments from model notes
« Reply #1 on: May 03, 2012, 12:56:34 pm »
Put comments in the Notes field of the table and column.

Select Comment Level: All on the Generate DDL dialog.

karu

  • EA Novice
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
Re: Oracle comments from model notes
« Reply #2 on: May 03, 2012, 02:37:32 pm »
Quote
Put comments in the Notes field of the table and column.

Select Comment Level: All on the Generate DDL dialog.

Thanks, that's what  I was after.