Migrate Data from SCSM 2012 R2 to a fresh new SCSM 2022

George Said 0 Reputation points
2024-03-19T11:17:29.97+00:00

I have an SCSM 2012 R2 environment distributed on 3 servers:
1- Operational management server 2012 R2
2-Data warehouse management server 2012 R2
3-Databases (operational and data warehouse). SQL 2012
All these servers run the operating system windows server 2012 R2 and the database version is 2012R2.
We need to do a fresh installation of SCSM 2022 with SQL 2022 and migrate the old data to it.
Is this applicable or not? if applicable any guides, please?
Also, if applicable, is there any concerns or risks?

Service Manager
Service Manager
A family of System Center products for managing incidents and problems.
209 questions
Microsoft System Center
Microsoft System Center
A suite of Microsoft systems management products that offer solutions for managing datacenter resources, private clouds, and client devices.
823 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. XinGuo-MSFT 14,236 Reputation points
    2024-03-20T02:07:02.4+00:00

    I would consider a new start with SCSM 2022, latest OS and SQL Server versions. the upgrade path is complicated because the upgrade of SCSM is like

    • SCSM 2012 -> SCSM R2 with Update Rollup 9 -> SCSM 2016 -> SCSM 2019 -> SCSM2022

    Parallel you need to upgrade the OS and the SQL Server version as well based on the requirements of each SCSM version:

    • SCSM 2016: SQL Server 2014/2014SP1 or SP2/2016 - Windows Server 2012R2/2016
    • SCSM2019: SQL Server 2014/2014SP1 or SP2/2016 /2017/2019 - Windows Server 2016/2019
    • SCSM2022: SQL Server 2017/2019 - Windows Server 2019/2022

    This means you have to upgrade a lot of components multiple times (SCSM, SQL Server and OS). Every update of a component carries the risk of an error or problem.

    • 4 upgrades of SCSM (SCSM 2012 -> 20212R2 UR9 -> 2016 -> 2019 -> 2022)
    • 2 upgrades of SQL Server (SQL 2012R2 -> 2016 -> 2019)
    • 2 upgrades of Windows Server 2012 R2 (Windows Server 2012R2 -> 2016 -> 2019)

    Also you have to check if all customizations, mostly 3rd party solutions in SCSM 2012 or your own customizations, are possible to migrate. SCSM 2012/2012R2 is using .Net 3.5 and SCSM 2016 and above require .Net 4.5.1. This adds some more efforts during the migration and increase the risk for errors/issues.

    0 comments No comments