Before attempting to convert your R:BASE Turbo V-8 database(s) with R:BASE 11, the next step is advised if regular database maintenance (PACK/RELOAD) is not performed, to ensure a proper conversion.
The following will create a copy of the database that is completely rebuilt with the structure, data, and indexes reloaded.
| 1. | Launch R:BASE Turbo V-8 |
| 2. | Navigate to your database directory by selecting "Utilities" > "Set Current Working Directory..." from the main Menu bar. |
| 3. | Go to the R> Prompt window (third button from the left on the Tool Bar) |
| 4. | At the R> Prompt, type: DISCONNECT , then press [Enter] |
5. At the R> Prompt, type: RENAME DbName.RX* BckupDB.RX* , then press [Enter]. "DbName" would be the actual name of your R:BASE database.
6. At the R> Prompt, type: CONNECT BckupDB , then press [Enter]
7. At the R> Prompt, type: RELOAD DbName , then press [Enter]
The database will now be rebuilt. If database errors occur at any point during the rebuild process, check the integrity of the database files.
8. At the R> Prompt, type: CONNECT DbName , then press [Enter]
9. Now connect back to your database after the rebuild, check your database to ensure the contents are intact.
10. After the database is checked, close R:BASE and continue with the steps below.
At this point, you must have R:BASE 11 installed on your computer. Be sure to review the R:BASE 11 Getting Started Guide regarding the installation and set up for your R:BASE software. The Getting Started Guide is located in the R:BASE program directory.
If there is no OWNER
| 1. | Install and launch R:BASE 11 |
| 2. | Navigate to your database directory using the "Change Current Folder" button (bottom left corner, folder icon with a green arrow, at the Database Explorer) |
| 3. | Go to the R> Prompt window (third button from the left on the Tool Bar, or press [Ctrl]+[R]) |
| 4. | At the R> Prompt, type: SET MULTI OFF , then press [Enter] |
| 5. | At the R> Prompt, type: SET STATICDB OFF , then press [Enter] |
| 6. | At the R> Prompt, type: TURBO DBNAME V9 , then press [Enter] |
| 7. | At the R> Prompt, type: CONNECT DBNAME , then press [Enter] |
If there is an Owner
| 1. | Install and launch R:BASE 11 |
| 2. | Navigate to your database directory using the "Change Current Folder" button (bottom left corner, folder icon with a green arrow, at the Database Explorer) |
| 3. | Go to the R> Prompt window (third button from the left on the Tool Bar, or press [Ctrl]+[R]) |
| 4. | At the R> Prompt, type: SET MULTI OFF , then press [Enter] |
| 5. | At the R> Prompt, type: SET STATICDB OFF , then press [Enter] |
| 6. | At the R> Prompt, type: TURBO DBNAME V9 IDENTIFIED BY ownername , then press [Enter] |
| 7. | 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 11.
| 1. | Connect to the database and open the R> Prompt. |
| 2. | 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= `
| 3. | 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)
| 4. | Disconnect the database. |
At the R> Prompt, type:
DISCONNECT
| 5. | Now rename the database that was just unloaded in Steps 1-3. |
Review the list of Databases in the R:BASE Database Explorer, and select the "Rename" option. Enter a new name for the database.
| 6. | Finally, use R:BASE to rebuild the database by running the .ALL file. |
At the R> Prompt type:
RUN filename.ALL
These steps will build a clean database!
With the database file conversion complete, proceed to the chapter for converting R:BASE 7.x/Turbo V-8 Forms, Reports, & Labels.
