Kbase P98600: How to convert a database from version 9 to version 10 when the directory is different?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
30/10/2007 |
|
Status: Verified
GOAL:
How to convert a database from version 9 to version 10 when the directory of the database is different ?
GOAL:
How to repair the structure of a Progress 9.x database on a Progress 10.x machine?
GOAL:
How to run prostrct repair for a version 9 database when there is no Progress 9.x installed ?
GOAL:
How to run Progress 9.x utilities on a machine that only has Progress 10.x installed ?
GOAL:
How to run prostrct repair on a Progress 9 database with OpenEdge10?
GOAL:
How to truncate the bi file of a Progress 9 database with OpenEdge10?
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.x
Progress 9.x
FIX:
The following scenario outlines a situation where:
A version 9.x database has been moved to a new machine where OpenEdge 10.x has been installed and
The directory to where the version 9 database has been placed on the new machine, is different to what it was originally.
** please note: the following is only if the migration is between Progress versions for the /same/ supported Platform **
STEPS:
1.) From an environment where the DLC and PATH environment variables have been correctly set for OpenEdge 10.x, 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
6.) Convert the version 9 database to version 10 database with conv910:
proutil <dbname> -C conv910
Congratulations! You now have an OpenEdge 10.x database (which you may want to take a baseline backup of with the OpenEdge executables).