Get the SQL Server options from the bacpac model.xml file

Get-D365BacpacSqlOptions [[-Path] <String>] [<CommonParameters>]

Extract the SQL Server options that are listed inside the model.xml file originating from a bacpac file

Get-D365BacpacSqlOptions -Path "c:\temp\d365fo.tools\bacpac.model.xml"

This will display all the SQL Server options configured in the bacpac model file.

Export-D365BacpacModelFile -Path "c:\Temp\AxDB.bacpac" | Get-D365BacpacSqlOptions

This will display all the SQL Server options configured in the bacpac file. First it will export the model.xml from the "c:\Temp\AxDB.bacpac" file, using the Export-D365BacpacModelFile function. The output from Export-D365BacpacModelFile will be piped into the Get-D365BacpacSqlOptions function.

Path to the extracted model.xml file that you want to work against

Type: String
Parameter Sets: (All)
Aliases: File, ModelFile

Required: False
Position: 1
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False

This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.

Tags: Bacpac, Servicing, Data, SqlPackage, Sql Server Options, Collation

Author: Mötz Jensen (@Splaxi)