Re: Designer/2000 stiffles full software life-cycle ?

Shafik A. Mahomad wrote:

> ...
>
> Somehow Designer ignored all previously mapped columns and created all new
> primary and foreign keys with all those strange names one more time and,
> retained the previously renamed columns. This is one major major pain we felt
> with the tool, anyone knows how to sidestep this "feature" ?
>
Setting the Run Options in the Data Design Wizard to Update rather than create should avoid this issue.

> The next BIG trouble was in reflecting the changes in the database
> model to the test database! The only way found was to drop the
> modified tables with the cascading option, and run the scripts Designer
> generated for all the related tables. This is extremely annoying and
> time-consuming with great potential for dangerous mistakes.
>

Why did you not use the Alter Table SQL Script that the Reconciliation Utility Can Create?

> ...

-- 


The statements and opinions expressed here are my own and   
do not necessarily represent those of Oracle Corporation.