We are evaluating the EA – Corporate edition and planning to buy in future.
I am trying work on our .eap project file, but some issues we found, please clarify on these.
1. Not able to create <<enumeration>> table and its links.
a) We have a package called customer, in which some tables and <<enumeration>> are there,
when I try to create table using "Transform Current Package" and selected "DDL" and "include child packages option"
and clicked do transform.
b) Then created “DLL.sql” using "Code engineering" -> "Generate DDL", here also I have selected "Include all child packages".
c) But in “dll.sql” not able to find any <<enumeration>> tables.
Please check the following sample, i can see customerkind data type,
but there is no Customerkind table or object found in “DDL.sql” file.
(We are using => MYSQL database)
e.g.
CREATE TABLE Customer
(
kind CustomerKind NULL,
pucNumber VARCHAR(50) NULL,
specialNeed VARCHAR(50) NULL,
status Status NULL,
vip BIT NULL,
customerID INTEGER NOT NULL,
PRIMARY KEY (customerID),
KEY (customerID)
) ;
2. Found Constraint names duplicate in “ddl.Sql” file. (CustomerAgreement )
eg.
ALTER TABLE JoinCustomerAgreementToEquipment ADD CONSTRAINT CustomerAgreement FOREIGN KEY (customerAgreementID) REFERENCES CustomerAgreement (customerAgreementID);
ALTER TABLE JoinCustomerAgreementToPricingStructure ADD CONSTRAINT PricingStructure fOREIGN KEY (pricingStructureID) REFERENCES PricingStructure (pricingStructureID);
ALTER TABLE JoinCustomerAgreementToPricingStructure ADD CONSTRAINT CustomerAgreement FOREIGN KEY (customerAgreementID) REFERENCES CustomerAgreement (customerAgreementID);
ALTER TABLE JoinCustomerAgreementToServiceLocation ADD CONSTRAINT ServiceLocation FOREIGN KEY (serviceLocationID) REFERENCES ServiceLocation (serviceLocationID);
ALTER TABLE JoinCustomerAgreementToServiceLocation ADD CONSTRAINT CustomerAgreement FOREIGN KEY (customerAgreementID) REFERENCES CustomerAgreement (customerAgreementID);
Please let me know how to handle ths problem, as we are planning to use ths tool for current and future projects.
