How to do SQL Server upgrade from version 2012 to 2017 while updating Bonita to 2021.2?

Q&A
1

Hi,

We are using SQL server 2012 for Bonita 7.8.4. We are planning to upgrade the Bonita version to 2021.2. SQL server 2017.

What is the happy path ?

Can I upgrade my SQL Server version after I'm done with the full bonita update to 2021.2?

Or dd I need to stop in the middle after update to version 7.10, then upgrade my SQL server version to 2017 and then continue with the migration, like it's described for Oracle here? : https://documentation.bonitasoft.com/bonita/2021.2/version-update/migrate-from-an-earlier-version-of-bonita#oracle19

Thanks for you help,

2

Hi,

The happy path should be simpler than for Oracle, as with SQL Server 2017, we did not notice any incompatibility between the 2012 and the 2017 versions, neither with the JDBC drivers that handle the migration update part or the runtime.

So you should totally be able to update to Bonita 2021.2 in one shot, upgrade your SQL Server version, and restart the server.

Hope this helps.

Emmanuel

3

Thanks Manu, I've created a PR in the documentation ;-)