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.
- 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
------------------------------
