topic Re: Database Version For Blueprism 7.0.1 in Product Forum

Database Version For Blueprism 7.0.1

PratyushLNU — Tue, 14 Dec 2021 13:30:21 GMT

Thanks for your answer.

Right now we are using Blueprism version 6.9 which is compatible with SQL Server 2012.

We are planning to upgrade to version 7.0.1. So, is SQL Server 2012 compatible with BP version 7.0.1.

Regards,
Pratyush

Re: Database Version For Blueprism 7.0.1

NicholasZejdlik — Tue, 14 Dec 2021 14:35:15 GMT

The database version is referring to the BPADBVersion table, which contains a list of all of the applied database changes. I believe the reason behind this is to make it easier for Blue Prism to make database upgrades, since it can scan easily for which necessary packages are missing. You can check the database version in Blue Prism by going into Configure Connection -> Upgrade Database -- it will show the current database version. Alternatively, this SQL query will also give you the current database version: Select Max(Convert(int, dbversion)) From BPADBVersion

Re: Database Version For Blueprism 7.0.1

PratyushLNU — Wed, 15 Dec 2021 09:56:08 GMT

Hi Nicholas,

Thanks for your answer.

Right now we are using Blueprism version 6.9 which is compatible with SQL Server 2012.

We are planning to upgrade to version 7.0.1. So, is SQL Server 2012 compatible with BP version 7.0.1.

Regards,
Pratyush

Re: Database Version For Blueprism 7.0.1

NicholasZejdlik — Wed, 15 Dec 2021 13:53:24 GMT

Here's a link to the software and hardware requirements. It looks like SQL Server 2012 is listed a deprecated, I would imagine it would work right now but might not in future versions.