@Marcus Wong Theen Nam
Here is my test result and I would like to share with you in Server 2012R2:
- Stop the WSUS Administrator Website in IIS
2)Back the SUSDB database in the SQL server and Delete the SUSDB in the SSMS console
3)Reinstall a new WSUS role in the Windows Server 2019 with the SQL server database and finish the post install the New WSUS.
4)Stop the WSUS Administrator Website in IIS after the installation finished
5) Offline the SUSDB in the SQL Server
6) Restore the SUSDB by the command:
RESTORE DATABASE SUSDBFROM DISK = 'C:\backup\SUSDB.bak' WITH REPLACE
7) Start the WSUS Administrator Website in IIS
8) Change the FQDN(Server name and IP address) to the old WSUS. The pointed computers will report to the new WSUS(Server 2019)
Note that there is no such document from MS for reference and this solution is not recommended by MS. So we cannot guarantee that there will be no problems during deployment. I just want to share my test result for your reference.
Hope the above will be helpful.
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.