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
isourcedatabase 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
| Command | Parameters | Example | Description |
|---|---|---|---|
| Help | -help | Prints the help text. | |
| Upgrade | inputparameters; applicationname; fromversion |
| Upgrades the Content Manager database to the latest version. |
| TerminateActiveDatabaseUpgrade | inputparameters | -terminateactivedatabaseupgrade --inputparameters "inputparameters.xml" | Terminates an upgrade that has unexpectedly stopped, before starting a new upgrade.
|
| Setup | applicationname; path | -setup --applicationname "InfoShareAuthor" --path "SetupScript.xml" | Adds custom specific fields. |
| FullExport | applicationname; path | -fullexport --applicationname "InfoShareAuthor" --path "FullExportResults.xml" | Retrieves the information relative to fields, LOVs and card types from the database. |