PsDac connects DacFx and PowerShell. It gives you PowerShell Cmdlets with the power of Microsoft.SqlServer.DacFx.
Imports a model from a dacpac or a database.
Import-DacModel [-Path] <FileInfo> [-ModelStorageType <DacSchemaModelStorageType>] [-LoadAsScriptBackedModel]
[-Service <DacServices>] [<CommonParameters>]
Import-DacModel [-DatabaseName <String>] [-ModelStorageType <DacSchemaModelStorageType>]
[-LoadAsScriptBackedModel] [-Service <DacServices>] [<CommonParameters>]
Provides a model object to access it’s definition.
PS C:\> Import-DacModel -Path ./WideWorldImporters.dacpac
Version : Sql130
EngineVersion : 13
IsScriptBacked : False
DisplayServices : Microsoft.SqlServer.Dac.Model.SqlDisplayServices
CollationComparer : Microsoft.SqlServer.Dac.Model.SqlModelCollationComparer
Name of the source database
Type: String
Parameter Sets: Database
Aliases:
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
Type: SwitchParameter
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: False
Type: DacSchemaModelStorageType
Parameter Sets: (All)
Aliases:
Accepted values: File, Memory
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
Specifies the path to the dacpac to load the model from.
Type: FileInfo
Parameter Sets: File
Aliases:
Required: True
Position: 0
Default value: None
Accept pipeline input: True (ByPropertyName, ByValue)
Accept wildcard characters: False
Specifies the server to extract the package from. Default is the latest connected service.
Type: DacServices
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: None
Accept pipeline input: False
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.