Export (0) Print
Expand All

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.

NoteNote

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

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

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft