Messages

1

General Board / Re: Oracle comments from model notes

« on: May 03, 2012, 02:37:32 pm »

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.

2

General Board / 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