I usually do this:
OUTPUT Before.txt
LIST TABLES
OUTPUT Screen
SET NULL -0-
OUTPUT dbname.dat
UNLOAD DATA
OUTPUT dbname.str
UNLOAD STRUCTURE
OUTPUT SCREEN
RBEDIT dbname.str
Go to the first ALTER TABLE statement
Select it and everything else to the end of the file, copy it to the
clipboard
Make a new file dbname.ind
Paste the clip.
Save the file
Return to dbname.str and delete what you just pasted.
You will now have three files:
dbname.str
dbname.dat
dbname.ind
Move the database (or these three files) into another directory
Run the three files in the above order.
OUTPUT After.txt
LIST TABLES
OUTPUT SCREEN
Compare the two sets of row counts.
If they are all matched, you now have a new, clean, database.
Albert
On 18/09/2012 3:39 PM, Javier Valencia wrote:
Marc,
Look at what you get when you run UNLOAD ALL. You will notice that the
command generates code to create the structure first, load the data
next and finally create keys and indices.
Do an UNLOAD ALL for both databases, separate the three section
mentioned above into 3 files. Run the first file (from the current
database) to create the new database structure, Load the data (second
file from the client database), and then run the third file (from the
current database) to create key sand indices. That should do it. This
assumes, of course that both databases have the same file structure;
if not you will have to edit files as needed.
Javier,
Javier Valencia, PE
O: 913-829-0888
H: 913-397-9605
C: 913-915-3137
*From:*[email protected] [mailto:[email protected]] *On Behalf Of *MDRD
*Sent:* Tuesday, September 18, 2012 1:31 PM
*To:* RBASE-L Mailing List
*Subject:* [RBASE-L] - Update an old user
Hi
Is there an easy way to update an old user to my new application?
There version of my app is 3 years old and it is hard to remember all
the changes we have made since then. So, I was thinking about
deleting Unloading all their data then load it into an empty copy of
my program. The main problem I can think of is if the data will load
in the correct order so the PK’s get loaded first then FK’s.
Is there an easy way to handle this?
Thanks
Marc
No virus found in this message.
Checked by AVG - www.avg.com <http://www.avg.com>
Version: 2012.0.2221 / Virus Database: 2437/5275 - Release Date: 09/18/12
--- RBASE-L
=======================3D=======================3
D=
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)
=======================3D=======================3
D=
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
=======================3D=======================3
D=
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
=======================3D=======================3
D=
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.
=======================3D=======================3
D=
