In tool comes with default installation package (v18.104.22.168983 and above). It is important that you install DbUpgrade module in the installation step (this module is installed by default if you choose client installation. If you choose server installation, you have to choose this module manually):
After installation, the tool is located by default at: **C:\Program Files (x86)\process4biz\DBUpgrade\DbUpgradeAll.exe **
You do not need administrator rights to start the tool, but if you want to have a log file, then you will need write-permissions on the folder where DbUpgradeAll is located, i.e. where log file will be saved.
DBUpgradeAll takes all databases that are saved in the DbConfig.xml file (that can be changed in Client Settings menu in p4b) and tries to upgrade them using connection settings provided in that file.
- Copy DbConfig.xml file from the client to the (license) server
- Choose to import databases from this file:
- Mark databases you wish to be upgrade
- Click Save
- Run DbUpgradeAll.exe on the client machine
When you run the tool, it shows what has been updated or are there any errors. On the screenshot on the right you see the output of the tool:
- Section 1 shows how the tool was started, then it shows the current date (and the name of the log file that will be saved).
- Section 2 shows upgrading process of one databases EMPTY6_2. It shows current and destination versions of the database and successful completion of the upgrade
- Section 3 shows an example when DbUpgradeAll cannot connect to the database
The tool accepts the following (optional) arguments:
do not create a log file
turns on backup with default backup location (usually C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Backup). By default backup is off
specifies the backup path (must be absolute path), where backup of databases will be saved.
After executing the tool, you will find a log file saved in the same folder as the tool: