Documentation Center

Running DBUpgradeTool for maintenance

After installing or upgrading Content Manager, use DBUpgradeTool (DBUT) to perform an overall verification of the database, to update database objects such as views, indexes, packages and stored procedures, and to modify metadata structures.

Before you begin

  • The isource database user must have the System Administrator privilege.
  • The Content Manager server and Content Manager database must be available (up and running), complete and correctly installed. The installation ensures that the upgrade files and connections are in place to allow a successful upgrade.
  • DBUT has exclusive access to the Content Manager database. That means that before running the tool, you should stop all components and services, such as InfoShare Crawler, on all servers.

Procedure

  1. Sign in to the Content Manager application server as a Windows user with the Administrator user role.
  2. In Windows Explorer, go to the Content Manager installation directory, then go to \App\Setup\DBUpgradeTool\.
  3. Run DBUpgradeTool.exe
  4. Only if you use ADFS, use DBUT to configure the FishExternalID of the administrator user with a value such as domain\username, for the user who has to sign in to the system as administrator:
    1. In DBUT, select option 1: Maintenance.
    2. Select option 5: Append an user's external ID for initial STS sign-in.
    3. Choose the installation and then fill in the appropriate value for the Content Manager admin user.
  5. If you performed an upgrade, select the DatabaseUpgrade option.
  6. Press Enter to respond to a series of questions; the default options are sufficient for the following questions:
    • Select your recently installed project (thereby selecting the database location and user, upgrade script paths, version and so on).
    • Default for the application.
    The result is an upgrade from an older or same version to the installed version when applicable. The application pool needs to be restarted after a DBUT run.