Kbase P5341: How to Migrate a single volume Progress 7.x to Progress 9.x with conversion utilties
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/11/2008 |
|
Status: Verified
GOAL:
How to Migrate a single volume Progress 7.x to Progress 9.x with conversion utilties
GOAL:
How to Convert a single volume Progress 7.x to Progress 9.x with conversion utilities
FACT(s) (Environment):
Progress 7.x
Progress 9.x
All Supported Operating Systems
FIX:
Assuming:
- that the migration is over the same platform
- no Progress 8.x available
- dump and load is not acceptable
1.) Create a multi-volume structure file for you database:
# mv7d.st
d . F 1024
d .
b .
2.) Create the void database with the structure file:
prostrct create mvd mv7d.st
3.) Make the single volume and multivolume database:
procopy singlevol7 mvd
4.) Use the Progress 9.x utilities found in $DLC/bin/83dbutils.
First convert the database to version 8:
$DLC/bin/83dbutils/83conv78 mvd
Then truncate bi:
$DLC/bin/83dbutils/83truncatebi mvd
5.) Finally, convert to Version9
proutil mvd -C conv89
6.) Backup the database.
A new feature in Progress 9.1D, 'move schema' allows the truncation of area 6 once the schema has been moved.