Skip to Main Content

SQL Developer Data Modeler

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Compare Model - Comment vs Comment in RDBMS

user52268Jan 10 2012
Hi:

Version 3.1.0.691 on Windows 7 Enterprise 64-bit SP1

In Designer (Version 10.1.2.0.2, Configuration 4.0.12.97.6, Build 10.1.2.6.18), the Edit Table dialog box (Columns tab, Advanced button) has a section called Documentation, and under that it has a field called Comment, and also one called Description.

I imported a non-versioned Designer application folder into Data Modeler (DM) and did a compare against a model that was schema-captured via DM. In DM's compare tool, the Designer "Comment" is mapping to DM "Comment in RDBMS" and the Designer "Description" is mapping to DM "Comment", as shown in the target section (Designer, right hand side) of the Compare Models - Detail tab.

The DM "Comment" field has its Selected check box checked, and the "Comment in RDBMS" is not checked. The Options - DDL Options tab has its Include Comments box unchecked.

I'd like to bring across Designer's Description and put it into DM's Comment field but if I do that my master model will always show a delta when a future target schema is captured for comparison, since the Oracle database doesn't have a place to store a generic Designer "description", or DM Comment.

Question #1:
Is there a way to globally disable the check box for DM's Comment field in the Compare tool? The Include Comments check box doesn't seem to affect it or the "Comment in RDBMS" field. This would also be a nice thing to know how to do in general for any DM field one might not want to consider in a comparison.

Thanks,

Doc
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 7 2012
Added on Jan 10 2012
0 comments
1,262 views