Consultor Eletrônico

Status: Unverified

GOAL:

Steps to convert a version 8.x single volume database to a version 9.X database.

GOAL:

How to migrate a version 8 database to version 9 database.

GOAL:

How to migrate a version 8 database to version 9 running on the same platform but different OS versions.

FACT(s) (Environment):

Windows
UNIX
Progress 8.x
Progress 9.x

FIX:

On the system where the Progress version 8 software is installed:
1. Convert the version 8 single volume database to a multi-volume database using Progress version 8 prostrct convert utility.
prostrct convert db-name
This command creates the following files: db-name.b1, db-name.d1, db-name.db, db-name.lg
2. Make a backup of the newly created multi-volume database using Progress v8 probkup utility.
probkup db-name db-name.bk
3. Create a structure file for the multi-volume database using Progress v8 prostrct list command.
prostrct list db-name db-name.st
This command creates a structure file (.st) for the multi-volume database using the database's name as the structure file's name.
4. Edit the structure file to remove all references to absolute paths. Replace references to absolute paths with a . (period).
For example:
d C:\wrk82\db-name.d1
would be replaced with
d . db-name.d1
5. Truncate the multi-volume database using Progress version 8 proutil truncate bi utility.
proutil db-name -C truncate bi
6. FTP the version 8 multi-volume database to the platform where version 9 is installed. FTP the following files:
db-name.b1, db-name.d1, db-name.db, db-name.lg, db-name.st
On the system were Progress version 9 software is installed:
7. Run the Progress version 9 database conversion utility using the proenv window to properly set the environment (DLC\bin\proenv).
proenv>proutil db-name -C conv89
8. Backup the newly converted database using Progress version 9 probkup utility.
probkup db-name db-name.bk