Export-SPAccessServicesDatabase

Reference

Module:: SharePointServer

Applies to:: SharePoint Server 2016, SharePoint Server 2019

Exports an Access Services Database to a DACPAC via the Data-Tier Framework.

Syntax

Export-SPAccessServicesDatabase
      [-AssignmentCollection <SPAssignmentCollection>]
      -DatabaseName <String>
      -ServerReferenceId <Guid>
      [<CommonParameters>]

Description

This cmdlet exports an Access Services Database to a DACPAC. The cmdlet requires the Data-Tier Framework to be installed on the SharePoint server where the cmdlet is run. The Data-Tier Framework packages can be found at Microsoft® SQL Server® Data-Tier Application Framework (17.4.1 GA DacFx). Install the following MSI from the download:

EN\x86\DacFramework.msi

Note: The x86 package is required. The x64 package is not compatible with this cmdlet.

See more information about Data-Tier Framework at Data-tier Applications.

Examples

Example 1

$contentdb = Get-SPContentDatabase ContentDbName
$accessDb = Get-SPAccessServicesDatabase -ContentDb $contentdb -EA 0 | Select -First 1
Export-SPAccessServicesDatabase -DatabaseName $accessDb.DatabaseName -ServerReferenceId $accessDb.ServerReferenceId | Set-Content -Path C:\accessDb.bacpac -Encoding Byte

This cmdlet retrieves the first Access Database from the specified Content Database and exports the Access Database to a BACPAC. This BACPAC file can then be imported via SQL Server Management Studio to restore the Access Database.

Parameters

-AssignmentCollection

Manages objects for the purpose of proper disposal. Use of objects, such as SPWeb or SPSite, can use large amounts of memory and use of these objects in Windows PowerShell scripts requires proper memory management. Using the SPAssignment object, you can assign objects to a variable and dispose of the objects after they are needed to free up memory. When SPWeb, SPSite, or SPSiteAdministration objects are used, the objects are automatically disposed of if an assignment collection or the Global parameter is not used.

When the Global parameter is used, all objects are contained in the global store. If objects are not immediately used, or disposed of by using the Stop-SPAssignment command, an out-of-memory scenario can occur.

Type:	SPAssignmentCollection
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	True
Accept wildcard characters:	False
Applies to:	SharePoint Server 2016, SharePoint Server 2019

-DatabaseName

The name of the Access Database.

Type:	String
Position:	Named
Default value:	None
Required:	True
Accept pipeline input:	True
Accept wildcard characters:	False
Applies to:	SharePoint Server 2016, SharePoint Server 2019

-ServerReferenceId

The ServerReferenceId used for the Access Database.

Type:	Guid
Position:	Named
Default value:	None
Required:	True
Accept pipeline input:	True
Accept wildcard characters:	False
Applies to:	SharePoint Server 2016, SharePoint Server 2019

Inputs

System.String

System.Guid Microsoft.SharePoint.PowerShell.SPAssignmentCollection

Outputs

System.Object