My existing WSUS setup on WS2012R2 and the SUSDB is created on a separate SQL 2017 cluster. I would like to migrate it to a new WS2019 Server. I am thinking of configuring the new server as a downstream replica server but wondering how should I cope with the SQL database. Appreciate if anyone could answer the below questions:
Can I configure the new WS2019 server to use WID instead of a database in existing SQL 2017 clustered instance? Will the updates and computer groups replicate to new server's WID?
If I am going to use back the same SQL 2017 cluster for new WSUS server, how should I proceed with that? Just setup a new WSUS 2019 server and point it to the SQL instance? Will I be able to see the existing config after pointing the DB or I will have to do some kind of downstream configuration?