Salesforce

How to migrate a database from any Progress version to version 9

Information

 
TitleHow to migrate a database from any Progress version to version 9
URL Name18435
Article Number000120594
EnvironmentAll Supported Operating Systems
Progress 7.x
Progress 8.x
Progress 9.x
Question/Problem Description
How to migrate the database from any Progress version to version 9
How to migrate the database from Progress 6.x to Progress 9.x
How to migrate the database from Progress 7.x to Progress 9.x
How to migrate the database from Progress 8.x to Progress 9.x
Steps to Reproduce
Clarifying Information
Error Message
Defect Number
Enhancement Number
Cause
Resolution
1)  Backup the database.

2) 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.

3) 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.

4) Truncate the BI file. It can be done using proutil <db-name> -C truncate bi from Progress 8.

5) Run proutil <db-name> -C conv89 from Progress 9. This should take under 5 minute regardless of database size.

6) Backup the database.

7) Add areas to the database.

8) 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.
Workaround
Notes
References to other documentation:
Progress Database Administration Guide and Reference

Progress Article(s):
"How to convert a 32-bit Progress 7.x database to Progress 8.x using conv78"
"How to Remove Storage Areas and Data Extents in Progress 9.x and 10.x"

Keyword Phrase
Last Modified Date11/20/2020 7:38 AM

Powered by