1) Open a
Progress 9 PROENV window by first bringing up a terminal or command prompt for your Operating System.
On windows: Start -> All Programs -> Progress -> Progress 9 and select: proenv.
UNIX command line: Go to where <Progress 9 is installed>/bin and execute the proenv command.
Windows command line: Go to where < Progress 9 is installed>\bin and execute the proenv command
2) Always have a verified offline backup prior to conversion. Backup the Progress 9 database using the version 9 executables:
$ probkup <dbname> <dbname>.bkp
$ prorest <dbname> <dbname>.bkp -vf
Starting with OpenEdge 11.2 the <DLC directory>/bin/91dbutils/conv911 script / batch is provided for converting a database from Progress 9 to OpenEdge 11 instead of the Steps outlined below.
$ DLC/bin/91dbutils/conv911 <dbname>
3) Truncate the Progress 9 database using the current version 9 executables:
$ proutil <dbname> -C truncate bi
4) Open a new
OpenEdge 11 PROENV window by first bringing up a terminal or command prompt for your Operating System.
On windows: Start -> All Programs -> Progress -> OpenEdge 11.x and select: proenv.
UNIX command line: Go to where <OpenEdge 11.x is installed>/bin and execute the proenv command.
Windows command line: Go to where <OpenEdge 11.x is installed>\bin and execute the proenv command.
5) Once PROENV has executed it will display the directory where OpenEdge 11 was installed and set the DLC environment variable.
Another environment variable needs to be set to reference this value as the default value of DLC will be changed throughout this exercise and finally reverted.
On UNIX:
ORIGDLC=$DLC;export ORIGDLC
On Windows:
set ORIGDLC=%DLC%
6) Convert the Progress 9 database to OpenEdge 10.
a) Set the DLC and PROCONV environment variables to point to DLC/bin/102dbutils.
On UNIX:
DLC=$ORIGDLC/bin/102dbutils;export DLC
PROCONV=$DLC/convmap.cp; export PROCONV
On Windows:
set DLC=%ORIGDLC%\bin\102dbutils
set PROCONV=%DLC%\convmap.cp
b) Convert the database from 9 to 10 using 102dbutils.
On UNIX:
$DLC/102b05_dbutil <dbname> -C conv910
On Windows:
%DLC%\102b05_dbutil <dbname> -C conv910
c) Truncate BI file using 102dbutils:
On UNIX:
$DLC/102b05_dbutil <dbname> -C truncate bi
On Windows:
%DLC%\102b05_dbutil <dbname> -C truncate bi
d) Optionally backup the database using 102dbutils:
On UNIX:
$DLC/102b05_dbutil -C probkup <dbname> <dbname>10.bkp
On Windows:
%DLC%\102b05_dbutil -C probkup <dbname> <dbname>10.bkp
7) Convert the now OpenEdge 10 database to OpenEdge 11
a) Set the DLC and PROCONV environment variables to the OpenEdge 11 installation.
On UNIX:
DLC=$ORIGDLC;export DLC
PROCONV=$DLC/convmap.cp; export PROCONV
On Windows:
set DLC=%ORIGDLC%
set PROCONV=%DLC%\convmap.cp
Alternatively open a new OpenEdge 11 PROENV window to set the environment to OpenEdge 11.
b) Convert the database from 10 to 11 using conv1011:
proutil <dbname> -C conv1011
c) Backup the database using OpenEdge 11:
probkup <dbname> <dbname>-11.bkp
