Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: karu on May 03, 2012, 12:04:50 pm

Title: Oracle comments from model notes
Post by: karu 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

Title: Re: Oracle comments from model notes
Post by: hd 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.

Title: Re: Oracle comments from model notes
Post by: karu 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.