please help! (problem about using ERWIN)

Hi, all,
I'm working on Database design with ERWIN, the target DB servers are ORACLE and SOLID (a high performance embedded DB, I connect it with ODBC).

but there is a problem when generate script for SOLID.

I created a logical model, and derived two physical models from it, one is used for ORACLE, another one for SOLID, which I use ODBC/GENERIC as its DATABASE.

The ORACLE schema script generated from the physical model is pretty good, so it can work correctly, but It looks like many problems with the ODBC scripts. One problem is ODBC scripts ALWAYS miss "NOT NULL" for all fields which have the "NOT NULL" constraints in the PHYSICAL model.

For example,
The script what ERWIN created:
CREATE PRODUCT (

     ID    INTEGER,
     PRIMARY KEY (ID) );

It can work under ORACLE, but the "NOT NULL" constraint has to set for ID attribute under SOLID.

Another one is "REFERENCE" scripts problem.

For example, the table script generated by ERWIN: CREATE TABLE CONDITION_VALIDITY (

        CONDITION_ID         INTEGER NOT NULL,
        START_TIME           TIMESTAMP NULL,
        END_TIME             TIMESTAMP NULL,
        PRIMARY KEY (CONDITION_ID),
        FOREIGN KEY (CONDITION_ID)
                              REFERENCES CONDITION

but in the SOLID, it has to write the attribute name in the reference table: CREATE TABLE CONDITION_VALIDITY (

        CONDITION_ID         INTEGER NOT NULL,
        START_TIME           TIMESTAMP NULL,
        END_TIME             TIMESTAMP NULL,
        PRIMARY KEY (CONDITION_ID),
        FOREIGN KEY (CONDITION_ID)
                              REFERENCES CONDITION (ID)

I wonder if there is a better way to solve it rather than edit script manually?

I appreciate you in advance!

Chen huaping Received on Fri Feb 01 2002 - 04:47:34 CST