Migrate SCCM CB2010 and SQL 2012 to new 2019 servers

Chong 846 Reputation points
2021-01-06T03:10:29.407+00:00

Hi all,

We have two Win2012 servers which installed SCCM CB2010 and SQL 2012 Server. Now we planning to migrate them to Win2019 server and SQL 2019 Server
Seems we can use backup and recovery to migrate the SCCM to new server.

For the SQL server, do we need to migrate the existing SQL server first? Or just backup the database and restore to new SQL 2019 Server? How about the reporting services

Thanks

Chong

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,799 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
494 questions
Microsoft Configuration Manager
0 comments No comments
{count} votes

6 answers

Sort by: Most helpful
  1. Chong 846 Reputation points
    2021-01-15T10:02:56.007+00:00

    @Fiona Yan-MSFT

    The console still cannot access today, and the log didn't increase anymore. So the installation is not complete and I need to setup another server to perform restore again?

    Thanks