DBUpgradeTool (DBUT), for all supported database engines, performs an overall verification of the database and updates database objects such as views, indexes, packages and stored procedures and modifies metadata structures.
Before you begin
- System Administrator rights for the
isource database user.
- Available, complete and correctly installed Content Manager server and Content Manager database (up and running).
The installation ensures that the upgrade files and connections are in place to allow a successful upgrade.
- Exclusive access to the Content Manager database for DBUT.
Be sure to stop all components and services, such as InfoShare Crawler, on all servers.
Procedure
- Login to the server as a Windows user with the Administrator user role.
- In Windows Explorer, in the Content Manager installation directory, open: \App\Setup\DBUpgradeTool\
- Locate and double-click on DBUpgradeTool.exe
- Optional, for ADFS only:
Use DBUT to configure the FishExternalID of the administrator user with a value such as domain\username, for the user who has to log in the system as administrator.
- Run DBUpgradeTool, select option 1: Maintenance.
- Select option 5: Append an user's externalid for initial STS logon.
- Choose the installation and then fill in the appropriate value for the Content Manager admin user.
- Select the DatabaseUpgrade option.
- Hit the Enter key to respond to all 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.