AREV Database Schema (AREV Specific)
At 08 JUN 2000 11:41:18AM Peter Heller (email: [email protected]) wrote:
Is there a way to dump the database schema in relational term (SQL) ?
If Not how do you display
the application tables,cloumns,indexes and relationships ?Are there any tools to acomplish this task ?
At 08 JUN 2000 12:23PM [url=http://www.sprezzatura.com" onMouseOver=window.status=Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:
This is unfortunately a manual process as AREV utilises non-self documenting nested tables within tables called "multi-values".
You will need to undertake a thorough manual examination. There are some clues that columns are foreign keys but they are not rigidly implemented. Similarly there are some clues that a one to many/many to many relationship exists between tables but they are not rigidly implemented.
For a small system creating a logical ERD without specific system knowledge can take a couple of days for an expert. For a large system we have taken in excess of two weeks before now.
World Leaders in all things RevSoft
At 08 JUN 2000 03:34PM Bob Rowland wrote:
Try the Rlist command at TCL prompt. This may give you some of what you need.
LISTDICT yourtablename (P
At 09 JUN 2000 08:00PM Richard Hunt wrote:
ohhhh Peter…
It sounds like you got a very very big problem on your hands. See, AREV is quite a bit of a step up over Microsoft databases. AREV is not that hard to learn, and well… since it is a very ummm… powerful database product, persons new to it will think it is very overwhelming.
I would suggest a number of things…
1) Get the AREV manuals.
2) Find someone to assist you. I mean employ them or get then contracted.
3) Take some classes in AREV.
4) It is not so easy to convert the AREV database to another ummm lesser quality product. There are multi-valued fields, internal conversion codes, and indexing that might not be available with the lesser quality product.
File structure in AREV can be very very deceiving. One file might coordinate with many other files. So what I am trying to say is that a little knowledge might be very very dangerous.