Re: Designer2000....reverse engineer tables?. Help!

Hi Keith,

> ....I installed Designer 2000 2.1 with my Oraclce8 database...and now want
> to reverse engineer some tables.... could you tell me in "general" how you
> get Designer 2000 to "see" the tables that I want to "reverse engineer"...I
> use the "Entity Retrofit" option, but the table that I want to retrofit does
> not appear...

Before you can run "table to entity" retrofit, you must reverse engineer the necessary tables. Reverse engineering will create the "definitions" of these tables in the in the Designer repository. The "table to entity retrofit" utility will show you a list of definitions for tables that do not correspond to any existing entities.

In the dialog box for the reverse engineer utility, you must provide the userid, password and the connect string for the schema that contains the tables to be reverse engineered.

>
> I saw the following in the documentation:
>
> "In the Entity Relationship Diagrammer or Repository Object Navigator,
> choose UtilitiesTable to Entity Retrofit. Note: This utility will run only
> against tables that are owned by the current application system. Entities
> are not created from shared tables."
>
> How did you get it so that the tables are owned by the current applilcation
> system?

In Designer, all table and entity definitions are owned by an application system. You must either create a new application system or use an existing one to reverse engineer the tables. You can do this through the RON.

HTH,
Sameer

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Jan 11 1999 - 21:35:46 CET