The PROUTIL CONV1112 utility converts the schema of an OpenEdge Release 11 database to OpenEdge Release 12.

Note: Converting without a replication rebase may allow a faster upgrade, for eligible versions of OpenEdge. See Prepare to convert replication-enabled databases and Convert replication-enabled databases without target rebase.

To convert the schema of an OpenEdge Release 11 database:

  1. Back up the database using OpenEdge Release 11.
    CAUTION: There is always a chance that your schema could become corrupt during conversion. If the conversion fails, your database cannot be recovered. If this happens, you must restore the backup copy of your database and begin the conversion again.
  2. Verify that the database is not in use.
  3. When your OpenEdge Release 11 database is enabled for Transparent Database Encryption (TDE) and has area, table, LOBs, or index data objects currently encrypted with RC4, you must complete the following steps before running the PROUTIL CONV1112 utility. If your database is not TDE-enabled, or is not using RC4 for any of its areas, tables, LOBs, or indexes, you may skip to step 4.
    1. Modify your OpenEdge Release 11 database to change the TDE policy for each RC4-encrypted table, index, LOB, or area to use an encryption algorithm that is supported in OpenEdge 12, such as AES-128.

      For details, see in Change the cipher of an encryption policy with PROUTIL EPOLICY in Learn about Security and Auditing.

    2. Update the encrypted data that is stored in the database.

      For an example, see EPOLICY MANAGE UPDATE example in Learn about Security and Auditing (an example of updating is described in steps 4 and 5).

    3. Make sure that the updated tables, indexes, LOBs, and areas show that all of the stored data is encrypted with the new algorithm.
  4. Truncate your before-image file with Release 11 PROUTIL TRUNCATE BI. You cannot truncate the before-image file of your Release 11 database with Release 12.
  5. Disable after-imaging, if enabled, with Release 11 RFUTIL AIMAGE END.

    If you have OpenEdge Replication enabled, you must disable it before you can disable after-imaging.

    For information on Replication, see OpenEdge Replication and After-imaging in Use Database Replication.

  6. Disable two-phase commit, if enabled, with Release 11 PROUTIL 2PHASE END.
  7. Verify your Release 11 backup, and then install OpenEdge Release 12, if you have not already done so.

    For information about how to install OpenEdge, see Before You Install in Install OpenEdge.

  8. Run PROUTIL CONV1112 to convert your database.

    Use the PROUTIL CONV1112 command, as shown:

    proutil db-name -C conv1112

    CONV1112 performs extensive checks of your database during a pre-scan process. If the pre-scan encounters any issues that would prevent a successful conversion, the issues are logged and the convert utility exits without making any changes to the database (it is still a valid Release 11 database).

  9. After you have successfully converted your database, back up your OpenEdge Release 12 database using Release 12 PROBKUP.
    • You should back up your Release 12 database in case it is damaged due to some failure. If you have only a Release 11 backup of your database, then you will need to go through the conversion process again.
    • Changes to large file support in OpenEdge Release 12 will impact databases created using CONV1112.

      For more information, see Database creation and large file support in Manage the OpenEdge Database.