Kbase 18435: How to migrate the Data base from any Progress version to version 9
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/11/2010 |
|
Status: Verified
GOAL:
How to migrate the Data base from any Progress version to version 9
GOAL:
How to migrate the Data base from Progress 6.x to Progress 9.x
GOAL:
How to migrate the Data base from Progress 7.x to Progress 9.x
GOAL:
How to migrate the Data base from Progress 8.x to Progress 9.x
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
FIX:
1) If the database is not a version 8 database, first convert it to version 8 by either using the conversion utility (Conv78 for Progress 7.x) or using Dump and Load.
2) If the database is single volume, you will need to convert it to a multi-volume database in Progress 8. It can be done using prostrct convert <db-name> from Progress 8.
3) Truncate the BI file. It can be done using proutil <db-name> -C truncate bi from Progress 8.
4) Run proutil <db-name> -C conv89 from Progress 9. This should take under 5 minute regardless of database size.
5) Backup the database.
6) Add areas to the database.
7) Move the data from area 6 to the areas you've just explicitly created.
Starting from 9.1D, you may use the option "mvsch" of proutil to truncate the schema area.