I ran reverse engineering for MS Access database and then converted result to Oracle 10g model . Using TDM naming conventions I was capable to get acceptable table and field names. Thanks, very good features.
I would just pay attention that TDM doesn’t’t validate table and attribute name length. Oracle’s restriction is 30 characters whereas MS Access fields can have much more.
verify model or Generate script doesn’t give any warnings about it… Hope it can be fixed in new versions.
But I don’t understand how naming conventions work for default values. After conversion from MS Access to Oracle all default values were in double quotes like “1” even for numeric field. Generated script has double quotes for default values as well and it is not acceptable for Oracle. I would consider it as TDM bug… Do you agree with that? Default values need to be in single quotes for varchar2 fields and no quotes for numeric fields.
I have about 100 fields with defaults… Do I really need to correct all of them manually or there is a way to correct them automatically in according with Oracle rules for defaults?
How do naming conventions work for defaults? Does it make sense to have any naming conventions for defaults for Oracle model?