< Back

Get-DatabaseChanges

Mon Jan 13, 2020 8:47 am

NAME Get-DatabaseChanges



SYNOPSIS

Get a list of differences between a dacpac and a database





SYNTAX

Get-DatabaseChanges -DacpacPath <string> -PublishProfilePath <string> [-DacFxExtensionsPath <string>]

[<CommonParameters>]





DESCRIPTION

Compares a dacpac to a database and returns a list of changes that need to be made to the database to get the

database in sync with the dacpac. This is the XML deployment report returned by the DacFx.





PARAMETERS

-DacpacPath <string>

The path to the dacpac to deploy



Required? true

Position? named

Default value

Accept pipeline input? true (ByPropertyName)

Accept wildcard characters? false



-PublishProfilePath <string>

The path to the publish profile. A publish profile contains lots of useful info like database name and any one

of the hundreds of config options for deploying. If you do not have a publish profile use New-PublishProfile

to generate a template that you can modify



Required? true

Position? named

Default value

Accept pipeline input? true (ByPropertyName)

Accept wildcard characters? false



-DacFxExtensionsPath <string>



Required? false

Position? named

Default value

Accept pipeline input? true (ByPropertyName)

Accept wildcard characters? false



<CommonParameters>

This cmdlet supports the common parameters: Verbose, Debug,

ErrorAction, ErrorVariable, WarningAction, WarningVariable,

OutBuffer, PipelineVariable, and OutVariable. For more information, see

about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).



INPUTS

System.String

The path to the dacpac to deploy



System.String

The path to the publish profile. A publish profile contains lots of useful info like database name and any one

of the hundreds of config options for deploying. If you do not have a publish profile use New-PublishProfile

to generate a template that you can modify



System.String





OUTPUTS





RELATED LINKS