Context: CU10 failed, reporting a corrupt master db when applied to SQL Server 2012 SP3 CU5. We built an empty new master on that server and will restore the backup of the CU5 master into a new CU5 instance on a different server. Now we need to replicate all settings from the restored CU5 master into the newly built CU10 master.
We cannot restore the backup of the CU5 master onto the CU10 instance of course, because the backup is from an older version. We are not concerned about master encryption key as we have not used SSRS, SSL or encryption on this server.
Best Answer
Fastest way... 1. Connect to instance with CU5 master 2. Right-click master database> tasks> Generate Scripts 3. Wizard is launched for scripting database objects. To get server principals: How to transfer logins and passwords between instances of SQL Server
Or, Powershell! Automated Script-generation with Powershell and SMO