Salesforce

What are the steps to migrate a database from 10.X to 11.X?

« Go Back

Information

 
TitleWhat are the steps to migrate a database from 10.X to 11.X?
URL Name000043128
Article Number000165002
EnvironmentProduct: OpenEdge
Version: 10.x, 11.x
OS: All supported platforms
Other: Database Migration
Question/Problem Description
What are the steps to migrate a database from 10.x to 11.x?
What are the steps to upgrade a database from 10.x to 11.x?
How to convert an OpenEdge database from version 10.x to 11.x?
How to migrate an OpenEdge 10 database when OpenEdge 10 is not installed on the server?
Can an OpenEdge 10 probkup be used for OpenEdge 11 migration?
Steps to Reproduce
Clarifying Information
Error Message
Defect Number
Enhancement Number
Cause
Resolution
To convert a database from OpenEdge 10.x to OpenEdge 11.x 
 

The following instruction uses :

  1. An OpenEdge 10.x offline PROBKUP
  2. Assumes OpenEdge 10 is not available to restore the backup in the OpenEdge 11 environment
  3. Uses the OpenEdge 11 <dlc>/bin/102dbutils to restore the database
  4. Then converts this database to OpenEdge 11 using conv1011

1.  Create an offline backup

Either 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.
 
Workaround
Notes
Keyword Phrase
Last Modified Date11/20/2020 7:30 AM

Powered by