Technically, in principal, one should at least once, perform a data
integrity check by re-building the entire database using the UNLOAD
ALL and then RUN filename.all command. This one step alone should
eliminate all unforeseen issues when converting/upgrading LEGACY database(s).
A few technical documents are available to explain such step-by-step
procedures.
From The Edge: http://www.razzak.com/fte/
Articles:
. Upgrading to R:BASE 7.6 for Windows (Database Conversion Guide - 04/17/2008
. Upgrading to R:BASE Turbo V-8 for Windows (Database Conversion
Guide) - 04/17/2008
. Database Maintenance (R:BASE 7.6 for Windows) - 12/29/2008
. Database Maintenance (R:BASE Turbo V-8 for Windows) - 12/29/2008
Very Best R:egards,
Razzak.
Sent from my iPhone
At 02:57 PM 5/20/2009, [email protected] wrote:
Yep, gave me an excuse to try to "select" from every view they had
defined to see what worked and what didn't! I didn't design the
database, and found a whopping 13 views that had invalid
definitions! Kept the definitions aside in a file, then deleted them all.
The reason I consider it "strange" is that I wouldn't have thought a
gateway import command would check database-wide table integrity,
just the integrity of the table you're importing into . And 6.5
(what we're converting from) either didn't check the database
tables, or it did check but just didn't give us an error
message. So this is a heads up as something to watch in a
conversion from 6.5 to 7.6.
Karen
It is not strange as mentioned in the subject line. It is the
relational integrity that R:BASE is known for over 25 years and
makes it what it is today.
It is the responsibility of end-user or developer to also
fix/correct View definition when underlying table structure is
altered. If ignored, R:BASE will generate -ERROR- messages.
Very Best R:egards,
Razzak.
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
