DB Upgrades in 19.5+
Knowledge shared by Oren
Beginning 19.5.0 the process of creation and upgrade of RPA Db has complete changed.
No SQL file are deployed with the version as separate files.
So what we do to upgrade and create DBs?
We've developed a tool that is doing all the upgrade and DB creation of the RPA DB all by itself.
It is being run from the installation kit automatically based on the parameters of the installation, and of course based on the permissions to the DB.
It is always deployed with the RPA server under c:KryonDB .
If you want to try it out, download the tool itself from here:
and the scripts that it uses from here (for v19.5.1 for example):
It is a command line tool.
DBUpCLI.exe up -? Will show you the CLI parameters for creating a new DB (FKA minimumDB) or upgrading existing DB
DBUpCLI.exe old -? Will show you the CLI parameters for upgrading from "old" version (pre 19.5) to the latest version.
"dry run" means to just create SQL file without executing it on the DB itself.
for next version the installation will create a SQL file ("dry run") even if there is DB Owner permissions on the target DB, for cases the upgrade fails, so it will be able to create one manually.
What the script does in case of upgrade from an "old" version is running the single script from the sub folder "old_to_MinDB". Each file name represents the source version of the existing DB.
In case of DB upgrade failure, you can try and run the relevant SQL file from this folder (post installation) manually.
The execution output of the DBUpCLi is written to a separate log file ends with *dbupcli.log in the %temp% folder.
Note that in case of failure with DB upgrade, you will get an error like the below during the installation process:
Most likely this kind of error will happen when the DB was modified manually post the previous installation.
It already happened for us twice this week.
In that case you can simple click "ignore" and run the relevant SQL script manually.
