First project with Rose, so this is a learning experience.
1) Rose was used to create the OM and then the DM, the DDL and finally the
database. Only one change was made to the DDL before the database was
created: changing the 'F' to 'RI' in the Rose generated DDL DROP statements
e.g. IF EXISTS (SELECT name FROM sysobjects WHERE name = 'JCS_JobSuite' AND
type = 'U') AND EXISTS (SELECT name FROM sysobjects where name =
'FK_JCS_JobSuite452' AND type = 'RI')
ALTER TABLE JCS_JobSuite DROP CONSTRAINT FK_JCS_JobSuite452. This
change was necessary because Rose generates DDL statements to drop based on
items of type = 'F', but generates DDL statements that creates items based
on type 'RI', rendering the DDL unusable after the first use.
2) Rose was purchased to simplify forward and backward reuse. The main
problem is that reverse engineering from the above database does not yield
an equivalent copy of the DDL that was used to create the database. Worse
yet, the new DDL is not a true representation of the database it is based
on; relationships are incorrect or completely missing. The relationship
changes cause other changes: where a table now only has 0..1 or 0..* on its
end, PKs are affected as well as FK and PFK designations.
This is serious because, at least for now the tool is a one-way device. The
'F'/'RI' problem is not a big deal because search/replace is an easy remedy.
Please tell me that I'm doing the engineering incorrectly or how to work
around it.
If this is the wrong forum, please tell me where to post.
Thanks,
Peter
Peter M. Lorenzetti
Bureau of Labor Statistics
2 Massachusetts Ave., N.E.
Washington, D.C. 20212
202.691.6692
[EMAIL PROTECTED]
************************************************************************
* Rose Forum is a public venue for ideas and discussions.
* For technical support, visit http://www.rational.com/support
*
* Post or Reply to: [EMAIL PROTECTED]
* Subscription Requests: [EMAIL PROTECTED]
* Archive of messages:
* http://www.rational.com/support/usergroups/rose/rose_forum.jsp
* Other Requests: [EMAIL PROTECTED]
*
* To unsubscribe from the list, please send email
* To: [EMAIL PROTECTED]
* Subject: <BLANK>
* Body: unsubscribe rose_forum
*************************************************************************
