DBUpgradeTool reference

DBUpgradeTool (DBUT) provides essential support in the Content Manager database management at every step of Content Manager life.

You can execute DBUpgradeTool:
  • By double-clicking DBUpgradeTool.exe located in the Content Manager installation directory: \App\Setup\DBUpgradeTool\. This is the interactive mode.
  • By opening DBUpgradeTool.exe in a command line console from the \App\Setup\DBUpgradeTool\ directory. This is the command line mode.

Requirements

System administrator rights
For the isource database user.
A running database
For a database to be upgraded, it must be operational (up-and-running).
A server installed by the Content Manager InstallTool
Upon installation, InstallTool verifies that a connection can be made given the current connectstring. It doesn't affect the database but verifies entries such as database name, location, user name and password, application, data and website paths, project name and Content Manager version.
Trisoft.Setup.DBUpgradeTool.Plan.xml
This file is part of every Content Manager version, it is created by Content Manager and describes the complete upgrade order. Do not modify the content of the file.
Exclusive access and all services stopped
DBUpgradeTool has exclusive access to the database and all services and components, such as InfoShare Crawler, are stopped on all servers. They must all be restarted afterwards.
Recommended: backup
A backup is recommended before any operation affecting the database, especially the scripts setup.

Specific to upgrade

DBUpgradeTool determines the current version of the database then runs the necessary SQL scripts to upgrade the Content Manager database to the Content Manager version that is installed.

Commands and parameters

CommandParametersExampleDescription
Help-helpPrints the help text.
Upgradeinputparameters; applicationname; fromversion

-upgrade --inputparameters "inputparameters.xml" --applicationname "InfoShareAuthor"

-upgrade --inputparameters "inputparameters.xml" --applicationname "InfoShareAuthor" --fromversion 12.0.0

Upgrades the Content Manager database to the latest version.
TerminateActiveDatabaseUpgradeinputparameters-terminateactivedatabaseupgrade --inputparameters "inputparameters.xml"Terminates an upgrade that has unexpectedly stopped, before starting a new upgrade.
Setupapplicationname; path-setup --applicationname "InfoShareAuthor" --path "SetupScript.xml"Adds custom specific fields.
FullExportapplicationname; path-fullexport --applicationname "InfoShareAuthor" --path "FullExportResults.xml"Retrieves the information relative to fields, LOVs and card types from the database.