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 or Password
| 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: NEWDB DBNAME , then press [Enter]
| 7. | At the R> Prompt, type: CONNECT DBNAME , then press [Enter] |
| 8. | At the R> Prompt, type: SET IDQUOTES=` , then press [Enter] (the ` quote character is the reverse single quote, which is next to the "1" and under the tilde "~", on American keyboards |
| 9. | At the R> Prompt, type: DISCONNECT , then press [Enter] |
10. Perform the "Complete Database Rebuild" instructions below
| 11. | Repeat "Steps 6-10" for all databases |
If there is a Username and Password
| 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: SET USER UserName Password , then press [Enter]
7. At the R> Prompt type: NEWDB DBNAME , then press [Enter]
| 8. | At the R> Prompt, type: CONNECT DBNAME , then press [Enter] |
| 9. | At the R> Prompt, type: SET IDQUOTES=` , then press [Enter] (the ` quote character is the reverse single quote, which is next to the "1" and under the tilde "~", on American keyboards |
| 10. | At the R> Prompt, type: DISCONNECT , then press [Enter] |
11. Perform the "Complete Database Rebuild" instructions below
| 12. | Repeat "Steps 6-11" for all databases |
If there is a database 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: SET USER OwnerName , then press [Enter]
| 7. | At the R> Prompt type: NEWDB DBNAME , then press [Enter] |
| 8. | At the R> Prompt, type: CONNECT DBNAME , then press [Enter] |
| 9. | At the R> Prompt, type: SET IDQUOTES=` , then press [Enter] (the ` quote character is the reverse single quote, which is next to the "1" and under the tilde "~", on American keyboards |
| 10. | At the R> Prompt, type: DISCONNECT , then press [Enter] |
11. Perform the "Complete Database Rebuild" instructions below
| 12. | Repeat "Steps 6-11" for all databases |
Database Rebuild
In addition to the above conversion steps, the following steps are advised 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 for Windows databases (filename.ALL and filename.LOB), and a single file for DOS databases.
| 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!
If there is a considerable amount of errors with both rebuilding the structure and/or data, please refer to the "Database Repair Routine" within the Database Maintenance PDF document in the R:BASE program directory.
With the database file conversion complete, proceed to the chapter for Converting Forms, Reports, & Labels.
