PowerShell™ for SharePoint® 2013 How-To

Modify Access Services Databases

Scenario/Problem: You need to modify the databases and/or database servers used by Access Services.

Solution: Use the cmdlets listed in this section to change database servers, server groups, or databases themselves.

This chapter covers the basic or more common cmdlets for creating and using Access Services objects. For more advanced scripting and modifications of these objects, the following cmdlets are available:

• Get-SPAccessServicesDatabase

• Get-SPAccessServicesDatabaseServer

• Set-SPAccessServicesDatabaseServer

• Get-SPAccessServicesDatabaseServerGroup

• Get-SPAccessServicesDatabaseServerGroupMapping

• Set-SPAccessServicesDatabaseServerGroupMapping

• New-SPAccessServicesDatabaseServer

• Remove-SPAccessServicesDatabaseServer ...