Hi,
I've created a new "Product" within the Database Datatypes, describing the data types in the TC211 family of standards. This is the default for all our logical class modelling.
I've defined a "Datatype Map" from that to Oracle, which is our physical database technology (wow - that's a painful interface!). For example, GM_Polygon maps to SDO_GEOMETRY. All that is safely stored in our .EAP file.
However, when I choose Code Engineering -> Reset DBMS Options (to open the "Manage DBMS Options" dialogue) and select Convert DBMS Type to convert from TC211 to Oracle, the results are patchy.
At a high level, quite a few things get converted properly - at least, most of the time. For example, CharacterString converts to VARCHAR2. Sadly, all these 'normal' types ignore anything about length, even when they get converted. More sadly, all those which should map to SDO_GEOMETRY come out as BLOB. And some 'normal' things seem to get missed (the odd Integer for example).
In practice, we have to revisit each attribute / column & set it manually. Is there any way to make this work reliably?
And is there anyway to export the mapping & load it into a different .EAP file?
Peter
