To convert a database from OpenEdge 10.x to OpenEdge 11.x
The following instruction uses :
- An OpenEdge 10.x offline PROBKUP
- Assumes OpenEdge 10 is not available to restore the backup in the OpenEdge 11 environment
- Uses the OpenEdge 11 <dlc>/bin/102dbutils to restore the database
- Then converts this database to OpenEdge 11 using conv1011
1. Create an offline backupEither run the PROENV script from <DLC install directory>/bin/proenv to set the DLC environment variable and update the PATH with the installation tailoring, or ensure the shell has these environment variables set:
[UNIX]
DLC=<path to OpenEdge installation directory>; export DLC
PATH=$DLC/bin:$PATH; export PATH
[WINDOWS]
set DLC=<path to OpenEdge installation directory>
set PATH=%DLC%\bin:%PATH%
Then cd to the directory where the database “dbname.db” file exists. The following Steps need to be undertaken using OpenEdge 10.x executables: 1. Ensure that the database is shutdown and no batch or cron jobs are running against it. 2. If the database is enabled for After-Imaging (AI) or OpenEdge Replication, these first need to disabled. Disable replication:
$ echo y | proutil source -C disablesitereplication source
Disable AI, which will also disable After-image Extent Management if enabled:
$ rfutil source -C aimage end
3. Truncate bi:
$ proutil db -C truncate bi -G 0
4. Take an offline backup the database to restoring in the OpenEdge 11 environment:
$ probkup dbname /<path>/dbname.bak10
5. Transfer the backup volume(s) to the where OpenEdge 11.x is installed. 6. Restore the database using the OpenEdge 10.x executables provided with the OpenEdge 11.x installation: 6a. Set the PROCONV environment variable to point to the OpenEdge 10.x convmap.cp:
[UNIX] PROCONV=$DLC/bin/102dbutils/convmap.cp; export PROCONV
[WINDOWS] set PROCONV=%DLC%\bin\102dbutils\convmap.cp
6b. Restore the backup volume(s). Note the 102dbutils/_dbutil executable may be renamed in different OpenEdge 11.x releases, please first check this against the current OpenEdge 11.x install.
[UNIX] $DLC/bin/102dbutils/102_dbutil prorest dbname /<path/dbname.bak10
[WINDOWS] %DLC%\bin\102dbutils\102b05_dbutil.exe prorest dbname \<path\dbname.bak10
Note: As long as a .st file with the same name as the DB name exist in the directory where the command above is being executed, the DB will be created with the same structure as the .st file. Otherwise the database will be restored with one extent for each area.
The following Steps need to be undertaken using OpenEdge 11.x executables: 7. Convert the restored database with conv1011 7a. Reset the PROCONV environment variable to point to the OpenEdge 11.x convmap.cp:
[UNIX] PROCONV=$DLC/convmap.cp; export PROCONV
[WINDOWS] set PROCONV=%DLC%\convmap.cp
7b. Convert the DB using OpenEdge 11.x:
$ proutil dbname -C conv1011
8. Backup the converted database:
$ probkup dbname /<path>/dbname.bak11
The database has been converted to an OpenEdge 11 database and started with OpenEdge 11 executables.After-Imaging, AI Management and/or Replication can be enabled as required.