Re: [Question] Designer2000

I have used Designer/2000 to reverse Oracle 7.3.4 on HP UX. Designer/2000 had some minor problems with tablespace and storage definition. Otherwise, it did a pretty decent job to give me a design model of the Oracle database.

It depends on what your meaning of the 'table definition' is. Designer/2000 is
able to add new columns, new indexes, new tables. It seems to have trouble to drop a column, a index, and some of the physical attributes of the storage
definition. Designer/2000 can generate script. It can also execute the script
on the fly.

Julien wrote in message <01be04c1$24135ac0$LocalHost_at_DEFAULT>...
>Hi !
>The application I am working in is undocumented.
>I would like to have an easy-to-read data model, but the application has
>over 300 tables. Is Designer 2000 a good tool for reverse engeneering ?
>
>The server is a Unix system. If I alter the definition of a table on a
>Win95 Client, I suppose that a "alter table" script is generated ? If so,
>do i have to move it to the server with ftp ?
>Or can I launch the script on the client and it will alter the table on the
>server ?
>
>What happens if several users try to alter the definition of a same table ?
>Is there a lock to avoid collision ?
>Thank you for your explanations !
Received on Sun Nov 01 1998 - 18:58:54 CET