Documentation Center

DBUpgradeTool overview

DBUpgradeTool assists you in essential operations on Content Manager database.

Automating or facilitating tasks on the Content Manager database improves safety in database evolution situations. Moreover, it lets those tasks be carried out by users who are not database administration experts. DBUpgradeTool also ensures that the same operations are performed on DEV, PROD and QA. For troubleshooting, all database upgrade information is stored in the same file: DBUpgradeTool.log.

DBUT has four uses:
  • Database upgrade and consistency check.
  • Full export providing the list of all fields, cards and list of values found in the database.
  • Script setup for any operation on fields, cards and list of values.
  • Termination of pending upgrade processes.
Upgrade
DBUT can handle statements from the upgrade such as:
  • Oracle database indexes, views, packages for Content Manager
  • Microsoft SQL Server indexes, views, stored procedures and functions for Content Manager
  • Setup files and database adaptations.
Full export
Before adding or changing fields, values or card types in the database, you need to get to know the database structure. The FullExport command of DBUT helps you do that. It produces a HTML report that can be analyzed in any browser.
Script setup
Once you have decided what would be the new fields and List of Values (LOV) in the database, their setup in the database is made by DBUT running your script.
Termination
If an upgrade fails, remaining upgrade processes may prevent another attempt. DBUT can kill any such processes.