Can we use the same mdb to upgrade windows server 2012 env to windows server 2019 env?

Products

• CA Service Management - Service Desk Manager

Issue/Introduction

We would like to upgrade the Service Management apps, including integrations, from current windows server 2012 env to windows 2019 env. Windows 2012 will reach end of support soon.

Can we install SM products using the current mdb and after windows 2019 servers' apps are up and running we retire the windows servers' apps?

Environment

Release : 17.3

Component : Catalog - Install

Resolution

This approach will not work.

One mdb is designed to support one set of SM and other apps, not multiple.

There are two approaches:

1. do in-place upgrade of the windows 2012 servers

this approach will be cost effective as there is no need for extra hardware and MS should support this kind of upgrade

2. install a brand new set of SM apps using a new mdb and then move the mdb data from the old mdb to the new one according to

https://techdocs.broadcom.com/us/en/ca-enterprise-software/business-management/ca-service-management/17-3/administering/moving-the-ca-mdb-data-from-the-source-to-the-target-systems/moving-the-ca-mdb-database-on-microsoft-sql-server.html

this approach will need extra set of hardware and more effect and time.