Migrate SCCM Primary site from Server 2012 R2 and SQL 2012 (SP3)

Question

Hi All, I hope you are doing well.

We are going to migrate our primary site SCCM 2107 Hotfix rollout (KB11121541) from:

Windows Server 2012 R2
Microsoft SQL Server 2012 (SP3-GDR) (KB4019092)

SQL and SCCM are located on the same Server.

The purpose is migration to Server 2022 and SQL 2019.

I am a bit confused about step-by-step plan. I would be happy to listen to your recommendation about the process and there are some questions:

1. We need to decide about DB location, as I see it is really good to locate SQL DB on the same server with Primary site , regarding the article https://stevethompsonmvp.wordpress.com/2014/12/20/why-you-should-not-use-remote-sql-server-with-configmgr-2012/

Is it still relevant for SCCM version 2107 and SQL 2019?

2. As we have SQL 2012 SP3 do we need to upgrade SQL before migration?
3. If yes, what is the scenario have to be? Upgrade SQL 2012 -> 2019 then restore DB on the new server with server 2022 and SQL 2019?
   But SQL 2019 is not officially supported with Server 2012 R2.
4. Can we restore DB from 2012 to 2019? I suppose no. What are your recommendations?

Any comments or suggestions will be very useful for me. Thank you in advance and have a great day.

Answer 1

Hello sir,

Thanks for your posting on Q&A.
I researched further on the Internet and also consult the SQL Server related Engineer. Here are my replies of your questions:

We need to decide about DB location, as I see it is really good to locate SQL DB on the same server with Primary site , regarding the article https://stevethompsonmvp.wordpress.com/2014/12/20/why-you-should-not-use-remote-sql-server-with-configmgr-2012/

Is it still relevant for SCCM version 2107 and SQL 2019?
Yes. It is recommended to SQL DB on the same server with Primary site.

As we have SQL 2012 SP3 do we need to upgrade SQL before migration?

It recommended to install a New SQL Server 2019 in the Windows Server 2022. And then restore the CM database.

Can we restore DB from 2012 to 2019? I suppose no. What are your recommendations?

Yes. It is recommended to Backup and Recover the Site Server and database. Here are several related useful links for your reference:
Backup:
https://learn.microsoft.com/en-us/mem/configmgr/core/servers/manage/backup-and-recovery
Recover:
https://learn.microsoft.com/en-us/mem/configmgr/core/servers/manage/recover-sites
Related Video:
https://www.youtube.com/watch?v=puQyt3aJsmY
The link isn't from MS, just for your reference.

SQL Server 2019: Hardware and software requirements:
https://learn.microsoft.com/en-us/sql/sql-server/install/hardware-and-software-requirements-for-installing-sql-server-2019?view=sql-server-ver16#hwswr

Thanks for your understanding. Have a great weekend.

Best regards,
Rita

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
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.