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

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. If your OpenEdge Release 11 database is enabled for Transparent Database Encryption (TDE) or has area, table, 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, 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 or index to use an encryption algorithm that is supported in OpenEdge 12, such as AES-128.

      For details, see Change the cipher of an encryption policy with PROUTIL EPOLICY.

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

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

    3. Make sure that the updated tables and indexes 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.

  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.

  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.

      See Database creation and large file support for more information.