COLLATIONUPGRADE is a one-time migration step that converts OpenEdge databases from an ICU 2.4 or 4.8 collation to an ICU 7.8 collation.
Note: Before running PROUTIL COLLATIONUPGRADE, you must disable AI and OpenEdge Replication.

Syntax

proutil db-name -C collationupgrade 
   [ -newCollation new-collation-name ] 
   [ -listCollations ]

Parameters

db-name
Specifies the name of the database.
-newCollation

Specifies the collation to apply to the database. The collation name must match a shipped .df file name, excluding the file extension.

-listCollations

Displays a list of the available collations.

Notes

  • Before running PROUTIL COLLATIONUPGRADE, disable AI and Replication.
  • After running the utility, run IDXBUILD to rebuild the database indexes.
  • Environments using Replication or Hot Standby will need to rebase target databases from a new backup after rebuilding the indexes.
  • The utility ignores auditing and CDC triggers while it runs, although those features remain enabled.