Progress
Database Administration
Guide and Reference


Converting a Version 8 Database To Version 9

The PROUTIL CONV89 utility converts the schema of a multi-volume Version 8 database to a multi-volume Version 9 database. To convert the schema of a multi-volume Version 8 database to the schema of a Version 9 database, follow these steps:

  1. Using Progress Version 8, back up your database.

CAUTION: There is always a chance that your schema could become corrupt during conversion. The conversion process consists of three phases. If the conversion fails after Phase 1 begins, your database cannot be recovered. Progress issues error messages that your database is corrupt. When this happens, you must revert to the backup copy of your database and begin the conversion again.
  1. Disable after-imaging and two-phase commit.You should disable after-imaging and two-phase commit before starting the conversion; however, if you forget to do so, PROUTIL will disable after-imaging and two-phase commit for you. PROUTIL issues an informational message when after-imaging and/or two-phase commit is disabled.
  2. Truncate your before-image file. PROUTIL will not convert your Version 8 database schema if you do not truncate the before-image file before you start the conversion.
  3. Verify that your Version 8 backup exists, then install Progress Version 9 following the instructions in the Progress Installation Notes .
  4. Execute PROUTIL -C CONV89 to convert your database:
  5. proutil db-name -C conv89 
    

    NOTE: For a complete description of the PROUTIL CONV89 utility, see Database Administration Utilities."

  6. After you have successfully converted your database, back up your Version 9 database.
  7. You should back up your Version 9 database in case it is damaged due to some failure. If you have only a Version 8 backup of your database, then you would need to go through the conversion process again to convert your Version 8 backup to a Version 9 database. Back up your Version 9 database before you start moving your tables and indexes out of the schema area.

  8. Create at least one application data storage area and move your user tables and indexes into it.
  9. By default, the PROUTIL CONV89 utility places all user tables and indexes in the schema area. Progress Software Corporation recommends that you move them to at least one application data storage area. For instructions on how to create a storage area and move tables and indexes into it, see the "Maintaining Indexes and Tables" section in Maintaining Database Structure."

  10. If you intend to enable two-phase commit, add a transaction log area to your Version 9 database. For a description of how to add storage areas to your database see the "Progress Structure Add Utility" section in Maintaining Database Structure."

Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095