Compare Model - Comment vs Comment in RDBMS
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