Please enable JavaScript to view this site.

R:BASE 11 Help

Navigation: Reference Index > Database Conversion > Converting the Database Files > Conversion Steps

Converting from R:BASE System V to R:BASE 4.0

Scroll Prev Top Next More

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.