To aid you in upgrading over multiple releases, OpenEdge provides you with utilities and a script to ease the database conversion process. The utilities are useful if you uninstall your older release of OpenEdge before completing the conversion, or if you are skipping over a release you never installed. The script assists you with the multi-step process of converting your Release 10.1A and higher database to Release 12.0.

Before conversion, the database before-image (BI) file must be truncated to ensure that there are no outstanding transactions.

For linux, in your install-dir/bin directory, the following utilities contain the files needed to truncate BI files and run the conversion utilities in the release that matches the directory name:
  • 101dbutils—For Release 10 to 10.1A, manually truncate BI files using 101a_dbutil, then use script conv1012 provided in 102dbutils to convert the database to Release 12.0.
  • 102dbutils—For Release 10.1B and higher, use script conv1012 provided in 102dbutils to truncate the BI files of a Release 10 database, convert the database to Release 11, and then convert the database to Release 12.
  • 117dbutils—For Release 11.0 and higher, manually truncate using 117dbutil, then use the Release 12 utility conv1112 to convert to Release 12.
Note: The permissions on the files in the *dbutils directories are different than those of the executables installed in the bin directory. Verify the permissions for UNIX with ls -l and adjust if necessary. The permissions must be defined in line with other permissions defined for users that administer the database. For example, if a Database Administrator group exists, you must modify the group ID for the files to that security group.

For Windows, 117dbutils is included in your <install-dir>/bin directory, whereas the following utilities are available as Progress® OpenEdge® Database Conversion Utilities on the Progress Electronic Software Download (ESD) website:

  • 101dbutils
  • 102dbutils

The conversion utilities do not support databases for releases prior to Release 10.1A. You must use the original installation utility for those databases.

For more information, see the README file in the directory.

If the release associated with the database has been removed, you may need to determine which conversion directory to use.
  • You may see this error when you try to connect:
    Database has the wrong version number. (db8342, pro:8365). (44)

    Parse the database log (.lg) file and search for (4234). For versions 11.7.2 and higher, this line lists the OpenEdge version that started the database. For more information, see the Progress Knowledge Base.

  • You may see this error when you try to convert:
    Conversion cancelled. 8342 is not a valid version number. (1285)

    This error happens if you try to convert more than one major version at a time, for example from version 10.1A to 12.0. You need to convert from one version to the next in order until you reach the required version. For example, convert from version 10.1A to 11.0 to 12.0. For each release, the PROUTIL command only supports the utility to convert from the immediate previous release to the current release.