Update-DbaInstance functionality to patch MDS only

[damian4]

Summarize Functionality

My understanding is Update-DbaInstance is designed to detect and update servers with the following Instance Features:

• Database Engine
• Analysis Services
• Reporting Services

For example, it will patch successfully if both Database Engine and a shared feature such as Master Data Services is installed and they will both be updated.

However, Master Data Services can be installed onto a machine without a database engine. If this happens, Update-DbaInstance fails to work because it does not detect an instance. Consequently, it returns an error.

Would like to request a feature, that supports patching standalone Master Data Services installs

Is there a command that is similiar or close to what you are looking for?

Yes

Technical Details

When a server only has Master Data Services and we try to patch it. We get the following warning and it doesn't patch.

Update-DbaInstance -ComputerName Server1 -Path "C:\temp\Patches"

WARNING: [09:39:50][Update-DbaInstance] Error while looking for SQL Server installations on SERVER1 | Failed to find any instance names on SERVER1