This topic has not yet been rated - Rate this topic

Master Data Services Cmdlet Reference (Windows PowerShell)

SQL Server 2008 R2

Master Data Services includes cmdlets to create and configure Master Data Services databases by using Windows PowerShell. These cmdlets are available in the MasterDataServicesSnapIn, which is located on the computer where you run Master Data Services Setup.

Note
You must open Master Data Services Configuration Manager at least once following Setup to register the MasterDataServicesSnapIn.

Adding the Snap-In

To use the Master Data Services cmdlets, first run the following command to add the MasterDataServicesSnapIn snap-in to the Windows PowerShell console:

Add-PSSnapIn MasterDataServicesSnapIn

Master Data Services Cmdlets

The following table provides a brief description of the Master Data Services cmdlets.

Cmdlet Name	Description
New-MasterDataServicesDatabase	Creates a Master Data Services database.
Get-MasterDataServicesDatabase	Gets information about a Master Data Services database.
Get-MasterDataServicesDatabases	Gets information about Master Data Services databases on a specified instance of SQL Server.
Get-MasterDataServicesDatabaseServerInformation	Gets connection information for a specified instance of SQL Server.
Get-MasterDataServicesIISInformation	Gets information about Internet Information Services (IIS) on the local computer.
Set-MasterDataServicesSystemSetting	Sets the value of a specified system setting in a Master Data Services database.
Get-MasterDataServicesSystemSettings	Gets system settings from a specified Master Data Services database.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD