Article

How to convert a database from Progress 9 to OpenEdge 10 when the database directory is different

« Go Back

Information

 
EnvironmentAll Supported Operating Systems
OpenEdge 10.x
Progress 9.x
Question/Problem Description
How to convert a database from version 9 to version 10 when the directory of the database is different ?
How to convert a database from version 10.x to version 11 when the directory of the database is different ?
How to repair the structure of a Progress 9.x database on a Progress 10.x machine?
How to run prostrct repair for a version 9 database when there is no Progress 9.x installed ?
How to run Progress 9.x utilities on a machine that only has Progress 10.x installed ?
How to run prostrct repair on a Progress 9 database with OpenEdge10?
How to truncate the bi file of a Progress 9 database with OpenEdge10?
Clarifying Information
Error Message
Defect/Enhancement Number
Cause
Resolution

Use these steps to convert a Progress version 9 database to OpenEdge 10 when the following conditions hold:  

  • A version 9 database has been moved to a new machine where OpenEdge 10 has been installed. 
  • The directory where the version 9 database has been placed on the new machine is different from what it was originally.
  • The migration is between Progress/OpenEdge versions on the same supported Platform.

STEPS:

1.  From an environment where the DLC and PATH environment variables have been correctly set for OpenEdge 10, place the following at the front of the PATH environment variable:

[WINDOWS]  PATH=%DLC%\bin\91dbutils;%PATH% 
[UNIX] PATH=$DLC/bin/91dbutils:$PATH; export PATH

2. Edit the structure file of the version 9 database so that all the paths to the database files are set to the fully qualified path

3. change the convmap to version 9:

[WINDOWS]  set PROCONV=%DLC%\bin\91dbutils\convmap.cp
[UNIX] PROCONV=$DLC/bin/91dbutils/convmap.cp; export PROCONV

4. Repair the version 9 database structure with the version 9 executable:

91_dbutil prostrct repair <dbname> <dbname.st>

5. Truncate the version 9 database with the version 9 executable:

91_proutil <dbname> -C trunc bi -G 3 

6. Take a backup of the version 9 database:

91_dbutil probkup <dbname> <device>

7. change the convmap to version 10:

[WINDOWS]  set PROCONV=%DLC%\convmap.cp
[UNIX] PROCONV=$DLC/convmap.cp; export PROCONV

8. Convert the version 9 database to version 10 database with conv910:

proutil <dbname> -C conv910

9. The database has been successfully converted to OpenEdge 10. It is recommended to make a baseline backup of the converted database at this point.
 

Workaround
Notes
To convert an OpenEdge 10 database to OpenEdge 11, follow the steps above using 101dbutils/101a_dbutil or 102dbutils/102b05_dbutil for both 91_dbutil and 91_proutil.  Use proutil <dbname> -C conv1011 to convert the database. 

References to Other Documentation:

Progress Article:

000029439, "How to convert a a database to OpenEdge11 without having OpenEdge10 installed"

Attachment 
Feedback
 
Was this article helpful?

   

Your feedback is appreciated.

Please tell us how we can make this article more useful.



Characters Remaining: 255

 



Copyright © 1993-2014. Progress Software Corporation. All Rights Reserved. See the next generation of application development and data connectivity software, try now!