topic RE: upgrade from SQL 2012 server to SQL 2019 server database in Product Forum

upgrade from SQL 2012 server to SQL 2019 server database

vipularora — Thu, 17 Jun 2021 11:24:00 GMT

If we upgrade from SQL 2012 server to SQL 2019 database then incremental backup is possible or not? is there any data loss in upgrade procedure?

------------------------------
vipul arora
------------------------------

RE: upgrade from SQL 2012 server to SQL 2019 server database

expertcr — Tue, 22 Jun 2021 18:31:00 GMT

We do not recommend this case; it is better to consult with your DBA or Microsoft.

------------------------------
Luis Lopez
Customer Support Engineer English and Spanish
Blue Prism Ltd
------------------------------

RE: upgrade from SQL 2012 server to SQL 2019 server database

chris.mcgowan — Thu, 24 Jun 2021 14:25:00 GMT

Hi Vipul,

In short no an incremental backup spanning multiple SQL Server versions is not possible. Irrespective of Blue Prism, upgrading the version of SQL Server is a one way operation, you can upgrade from SQL Server 2012 to SQL Server 2019 but you cannot downgrade. In place upgrades are fraught with risks, typically the approach would be to migrate the database(s) from a SQL Server 2012 server to a new SQL Server 2019 server. Steps (for the database migration alone) would be something like the below;

Take a FULL database backup of the SQL Server 2012 database.
Copy and restore the FULL database backup taken of the SQL Server 2012 database to the new SQL Server 2019 Instance.
1. During the restore SQL Server automatically upgrades the databases system objects to the new version
Test the database in isolation on the new SQL Server 2019 server
If all is ok, continue with the migration, if not the rollback would be to revert back to the original SQL Server 2012 instance.

There are many other factors to consider, which are far too numerous to list in a forum post. Blue Prism do offer a Product Upgrade Assurance service which can help you prepare to ensure that you have all the i's dotted and t's crossed. Please reach out to your account manager for further information.

Regards

------------------------------
Chris McGowan
Senior Technical Consultant
Blue Prism
------------------------------

RE: upgrade from SQL 2012 server to SQL 2019 server database

535008387 — Tue, 02 Nov 2021 13:33:00 GMT

You should check if your version of BP supports 2019. We are running 6.4 and 6.5 but 2019 is not officially supported for those versions. We are told support would be best effort.

------------------------------
Robert Hough
Project Manager
Royal Bank of Canada
America/New_York
------------------------------

RE: upgrade from SQL 2012 server to SQL 2019 server database

krishna.kodimurali9 — Sun, 14 Nov 2021 16:39:00 GMT

We generally have such confusion around upgrading DB for standalone installations,

------------------------------
MuraliKrishna
Senior Consultant - Automation Developer
------------------------------