SCCM database migration

Wasif Kazia Mohamed 1 Reputation point

We have our SCCM environment (Version 1910) running on Windows server 2016. SCCM database is deployed on Sql Server 2012 running on a Windows Server 2012. We are planning to migrate all the services running on Windows Server 2012 to the newer versions of Server (2016/2019). Plan is to move SCCM database including the reporting services currently on SQL Server 2012 to SQL Server 2017. Found the below link on the migration steps. Need advise if these steps are correct and also on moving the reporting services/database to the new SQL server

Microsoft Configuration Manager
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Garth Jones 2,071 Reputation points
    0 comments No comments

  2. AllenLiu-MSFT 27,751 Reputation points Microsoft Vendor

    Hi, @Wasif Kazia Mohamed
    Thank you for posting in Microsoft Q&A forum.
    Yes, we may refer to the steps you linked to migrate sccm database to another server.
    For reporting services, after the SQL Server database migrated, we need to reinstall the reporting service role on new server and if we have custom reports, we may export from the old server and import to the new server.

    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments