Documentation Center

DatabaseUpgradeTool (DBUT) overview

The DBUT allows upgrading using a DatabaseUpgradeTool, similar to InstallTool.

The tool can handle statements from the Upgrade such as:
  • Oracle RDBMs indexes, views, packages for TriDK, EventMonitor, and InfoShare Common
  • Microsoft SQL Server indexes, views, stored procedures and functions for TriDK, EventMonitor and InfoShare Common
  • TriDK Xml Setup and small TriDK 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 SDL LiveContent Architect grouped them together in one tool, developed to:
  • reduce the time needed to upgrade the SDL LiveContent Architect 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.

DatabaseUpgradeTool 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 DatabaseUpgradeTool and following the instructions.

The SDL LiveContent Architect database should be up, and all database satellites and services should be down to allow exclusive access for the tool, to the database.