Skip to content

Instantly share code, notes, and snippets.

@RichieBzzzt

RichieBzzzt/GetHelpPublishDbaDacpac.ps1

Created January 16, 2018 15:41
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save RichieBzzzt/0677f5e1da3dfa0d8fcb59a5593c1613 to your computer and use it in GitHub Desktop.
Save RichieBzzzt/0677f5e1da3dfa0d8fcb59a5593c1613 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
GetHelpPublishDbaDacpac.ps1
NAME
Publish-DbaDacpac
SYNOPSIS
The Publish-Database command takes a dacpac which is the output from an SSDT project and publishes it to a database. Changing the schema to match the dacpac and also to run any scripts in the dacpac (pre/post
deploy scripts).
SYNTAX
Publish-DbaDacpac [[-SqlInstance] <DbaInstanceParameter[]>] [[-SqlCredential] <PSCredential>] [-Path] <String> [-PublishXml] <String> [-Database] <String[]> [[-ConnectionString] <String[]>]
[-GenerateDeploymentScript] [-GenerateDeploymentReport] [-ScriptOnly] [[-OutputPath] <String>] [-IncludeSqlCmdVars] [-EnableException] [<CommonParameters>]
DESCRIPTION
Deploying a dacpac uses the DacFx which historically needed to be installed on a machine prior to use. In 2016 the DacFx was supplied by Microsoft as a nuget package and this uses that nuget package.
RELATED LINKS
https://dbatools.io/Publish-DbaDacpac
REMARKS
To see the examples, type: "get-help Publish-DbaDacpac -examples".
For more information, type: "get-help Publish-DbaDacpac -detailed".
For technical information, type: "get-help Publish-DbaDacpac -full".
For online help, type: "get-help Publish-DbaDacpac -online"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment