RE: Tips for Building the Designer2000 Repository

Thanks for all the feedback on Des2K.

I've discovered one very irritating lack of feature... For reverse-engineering or registering a database for retrofit the repository and the schema need to be in the same database. I discovered this AFTER having created the repository on another machine so now I need to recreate the repository on the main development database. The other tools I've used allow reverse engineering over SQL*Net with one DB connection to the repository database and another to the source database to be reverse-engineered or documented. The docs say you can import the schema from the source to the repository DB. This is crazy. Why is Oracle so dumb on this one?

Irritated at Oracle again,
Steve Orr

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of paquette stephane
Sent: Tuesday, July 18, 2000 1:05 AM
To: Multiple recipients of list ORACLE-L Subject: RE: Tips for Building the Designer2000 Repository

A stable data model ???
I've seen that in a dss application.
On oltp systems, I've been less lucky.

On the current project, I was in charge of studying the switch from AMC Designer to Oracle Designer 6. I've decided to stay with AMC Designer. Oracle Designer 6 was too much overhead (we're a .com) and very few people knew the product here.

At a previous client, we're using Designer 1.3.2, 2 Oracle gurus have spent weeks to configure it and build the templates, we achieve 90% generation.

I do not think 100% generation is possible. For example, the current version doesn't support Intermedia indexes which is common nowadays (since it's free).

• "Shockey, David" <DShockey_at_jwrinc.com> a écrit : > 1. What do you mean by a stable data model? It is
  > our intention to build
  > the systems from scratch using Designer. Some
  > business process
  > reengineering is an objective of the project. A new
  > data model will be a
  > product of the project, not something that we will
  > start with.
  >
  > 2. From my study (not experience) of Designer so
  > far it appears that the
  > possible methodologies are dictated by Designer. Is
  > this what you mean?
  >
  > 3. This implies that 100% generation is not
  > possible, at least on your
  > project. Are the forms changes that you make using
  > Developer incorporated
  > into the application version that is in the Designer
  > repository or is that a
  > part of the application that must be maintained
  > seperately?
  >
  > 4. I'll get in touch with him as we get closer to
  > installing and using
  > Designer.
  >
  > Thanks!
  >
  > -----Original Message-----
  > Sent: Monday, July 17, 2000 9:45 AM
  > To: Multiple recipients of list ORACLE-L
  >
  >
  > We am currently involved in a very large project
  > that is using Designer. I
  > would suggest that if you intend to use Designer
  > that you consider a few
  > things.
  > 1) Make sure you have a STABLE data model that
  > supports your business.
  > 2) If you buy into Oracle Designer then buy into the
  > Oracle methodology.
  > 3) Get Just in Time (JIT) training on Oracle Forms
  > esp.. a custom course on
  > Forms triggers.
  > 5) We have a gentleman on site that you NEED to
  > discuss your Designer
  > development strategy with:
  > David Wendelken
  > CASEtech Inc.
  > dwendelken_at_casetech.net
  > <mailto:dwendelken_at_casetech.net>
  >
  >
  >
  > Al Rusnak
  >
  > DSN 687-4937
  > COM (804)734-4937
  >
  >
  >
  > -----Original Message-----
  > Sent: Friday, July 14, 2000 2:08 PM
  > To: Multiple recipients of list ORACLE-L
  >
  >
  >
  > We are considering using Designer for application
  > development. In the real
  > world, how close can you get to 100% generation? If
  > changes are made using
  > Developer, can the changes be included in the
  > application version that is
  > stored in the repository?