Database upgrade

The database upgrade can be applied either via:

  • An in-product option, or
  • Through use of SQL Upgrade Script that is applied manually.

In-product upgrade

On a single client (typically the application server), click File > Connections. Ensure the relevant connection is selected and click Upgrade Database.

The connection to the database will require necessary database permissions to carry out the required changes.

Directly executed SQL Script (advanced)

The SQL upgrade script for the relevant Blue Prism version must be applied against all databases which are to be upgraded.

Once the database upgrade script has been executed against the relevant databases, the following command must be run against each of the affected Blue Prism environments from a single client (typically the application server).

  • Single Sign-On – automatec.exe /refreshdependencies /dbconname “[DBConName]” /sso
  • Blue Prism Native Authentication – automatec.exe /refreshdependencies /dbconname “[DBConName]” /user [Username] [Password]
    • DBConnName – The name of the Blue Prism Connection (as displayed within the client interface on the device where the command is being executed).
    • Username – The username used to log into the environment accessed using the specified Blue Prism Connection (only required where not using single sign-on for the Blue Prism platform).
    • Password – The password used to log into the environment accessed using the specified Blue Prism Connection (only required where not using single sign-on for the Blue Prism platform).