Kbase P4777: How to convert a Version 8.X database to 9.X using Conversion utilities?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/20/2009 |
|
Status: Verified
GOAL:
Is there a utility to convert a Progress 8.x database to Progress 9.x?
GOAL:
What is proutil conv89?
GOAL:
How to use conv89
GOAL:
How to convert a Progress 8.x database to Progress 9.x
GOAL:
How to migrate from version 8 to version 9.
GOAL:
How to migrate a multivolume 8.x database to 9.x
FACT(s) (Environment):
Progress 8.x
Progress 9.x
FIX:
Conv89 is the utility that can be used to convert a Progress 8.x database to Progress 9.x
The conversion can be done by following the enumerated steps.
In Progress 8.x installation perform the following:
1. Truncate the Progress 8.x database(s) before image file.
proutil dbname -C truncate BI2. Backup the Progress 8.x database(s).
3. Single volume databases must be converted to multi-volume before proceeding.
To convert a single volume database to multi-volume, from the %DLC%\bin directory, issue the following command:
prostrct convert dbnameUpon successful completion of the multi-volume conversion the conv89 utility can be used to convert the Progress 8.x database(s) to Progress 9.x.
4. Convert the multi-volume Progress 8.x database to a multi-volume 9.x database by performing the following from the Progress 9.x directory:
proutil db-name -C conv89After the successfully completion of the conversion the following message will be displayed:
Conversion completed, database is now in Progress 9.x format. (6525)
5. Backup the newly converted database.
It is advisable that Storage Areas be created at this time.
Individual storage areas allow the number of records per block to be set for the tables contained in that storage area. Setting the optimal number of records per a block for the tables will result in a performance gain.
Use the "proutil dbname -C tabanalys" to list the average size of the records for each table and to determine the optimal records per a block.