Documentation Center

DBUpgradeTool (DBUT) overview

The DBUT allows upgrading using a Database Upgrade Tool, similar to InstallTool.

The tool can handle statements from the Upgrade such as:
  • Oracle RDBMs indexes, views, packages for Content Manager
  • Microsoft SQL Server indexes, views, stored procedures and functions for Content Manager
  • TriDK XML Setup and small Content Manager Migration code
Several projects have indicated that there are less and less database administrator (DBA) people involved in upgrades. The manual upgrades by non-DBA people are error-prone. To reduce upgrading risks and allow better database upgrade logging Content Manager grouped them together in one tool, developed to:
  • reduce the time needed to upgrade the Content Manager database
  • eliminate the most common mistakes when upgrading
  • provide reproducible installations for DEV, QA and PROD
  • have one log file holding all database upgrade information, the DBUpgradeTool.log, which can be used for troubleshooting or reporting issues.

DBUpgradeTool should not be used:
  • to handle customer specific upgrades and/or information
  • by integrators or customers to handle their upgrades

Executing the program consists of starting DBUpgradeTool and following the instructions.

The Content Manager database should be up, and all database satellites and services should be down to allow exclusive access for the tool, to the database.