<div>
I would expect a downstream server to have settings like products and categories replicated ...
</div>


I would expect a downstream server to have settings like products and categories replicated ...

<div>
As a replica, it would, but when switching from replica to master or possibly in either mode, the selections might have to be made...
</div>


As a replica, it would, but when switching from replica to master or possibly in either mode, the selections might have to be made...

<div>
<div class="content wysiwyg-content">
I have stood up a new 2016 WSUS and was hoping to just move the database but even after closely following the procedure and mounting it in the new SQL2014, WSUS was unable to read it. &nbsp;I suspect it has something to do with a restructuring of the database: &nbsp;See this <a href="https://support.solarwinds.com/Success_Center/Patch_Manager/Critical_MSFT_update_KB3159706_causes_WSUS_restructure_for_Windows_10_updates" rel="ugc">https://support.solarwinds.com/Success_Center/Patch_Manager/Critical_MSFT_update_KB3159706_causes_WSUS_restructure_for_Windows_10_updates</a><br />
<br />
I have both the old SUSDB2 and the new one mounted in SQL and can toggle WSUS via the registry, &nbsp;Is there some other way to copy the approvals and declined update list to the new database?
</div>
</div>


I have stood up a new 2016 WSUS and was hoping to just move the database but even after closely following the procedure and mounting it in the new SQL2014, WSUS was unable to read it.  I suspect it has something to do with a restructuring of the database:  See this https://support.solarwinds.com/Success_Center/Patch_Manager/Critical_MSFT_update_KB3159706_causes_WSUS_restructure_for_Windows_10_updates

I have both the old SUSDB2 and the new one mounted in SQL and can toggle WSUS via the registry,  Is there some other way to copy the approvals and declined update list to the new database?

Migrate WSUS 3.2 to WSUS 10 (2016)

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Windows Server Update Services (WSUS), previously known as Software Update Services (SUS), is a computer program developed by Microsoft that enables administrators to manage the distribution of updates and hotfixes released for Microsoft products to computers.

WSUS

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.