At 04:26 PM 12/7/2012, Dan Goldberg wrote:
I am needing to get data from a backup 7.6 32 bit rbase
files(rb1-rb2-rb3-rb4). I am now using 9.5 64 bit.
I cannot open it with 9.5 and do not have 7.6 license anymore. How
do I open a old database and get data from it?
Dan,
You can use your existing version of R:BASE eXtreme 9.5 (64) to
convert R:BASE 7.6 database.
Use the TURBO command to convert the database.
Here's how:
If there is no OWNER
01. Launch R:BASE eXtreme 9.5 (64)
02. Navigate to your database directory using the "Change Current
Folder" button (bottom left corner, folder icon with a green arrow)
03. Go to the R> Prompt window (third button from the left on the
Tool Bar, or press [Ctrl]+[R])
04. At the R> Prompt, type: SET MULTI OFF , then press [Enter]
05. At the R> Prompt, type: SET STATICDB OFF , then press [Enter]
06. At the R> Prompt, type: TURBO DBNAME , then press [Enter]
07. At the R> Prompt, type: CONNECT DBNAME , then press [Enter]
If there is an Owner
01. Launch R:BASE eXtreme 9.5 (64)
02. Navigate to your database directory using the "Change Current
Folder" button (bottom left corner, folder icon with a green arrow)
03. Go to the R> Prompt window (third button from the left on the
Tool Bar, or press [Ctrl]+[R])
04. At the R> Prompt, type: SET MULTI OFF , then press [Enter]
05. At the R> Prompt, type: SET STATICDB OFF , then press [Enter]
06. At the R> Prompt, type: TURBO DBNAME IDENTIFIED BY ownername ,
then press [Enter]
07. At the R> Prompt, type: CONNECT DBNAME , then press [Enter]
Complete Database Rebuild
In addition to the above conversion steps, the following steps are
required to completely rebuild the database. These steps will be
performed in R:BASE eXtreme.
01. Connect to the database and open the R> Prompt.
02. Check the IDQUOTE settings of connected database.
At the R> Prompt, type:
SHOW CHARACTERS
Notice the last parameter, IDQUOTES
If IDQUOTES is set to NULL, you'll need to change NULL to the
appropriate character, such as ` (reversed quote) as following:
SET IDQUOTES= `
03. Unload the entire database. Use the SET USER command below if an
OWNER name exists.
At the R> Prompt, type:
SET NULL -0-
SET USER ownername
OUTPUT filename.ALL
UNLOAD ALL
OUTPUT SCREEN
This process will create two files (filename.ALL and filename.LOB)
04. Disconnect the database.
At the R> Prompt, type:
DISCONNECT
05. Now rename the database that was just unloaded in Steps 1-3.
Review the list of Databases in the R:BASE eXtreme Database
Explorer, and select the "Rename" option.
Enter a new name for the database.
06. Finally, use R:BASE to rebuild the database by running the .ALL file.
At the R:BASE eXtreme R> Prompt type:
RUN filename.ALL
These steps will build a clean database!
That's all there is to it!
Very Best R:egards,
Razzak.
www.rbase.com
www.facebook.com/rbase
