SqlPackage

Summary

Contains functionality related to SqlPackage.

In order to use the commands for this addin, you will need to include the following in your build.cake file to download and reference from NuGet.org:

#addin Cake.SqlPackage

DeployReport

SqlPackageDeployReport(ICakeContext, Action<SqlPackageDeployReportSettings>) Creates an XML report of the changes that would be made by a publish action.
Addin from Cake.SqlPackage.dll
SqlPackageDeployReport(ICakeContext, SqlPackageDeployReportSettings) Creates an XML report of the changes that would be made by a publish action.
Addin from Cake.SqlPackage.dll

DriftReport

SqlPackageDriftReport(ICakeContext, Action<SqlPackageDriftReportSettings>) Creates an XML report of the changes that have been made to a registered database since it was last registered.
Addin from Cake.SqlPackage.dll
SqlPackageDriftReport(ICakeContext, SqlPackageDriftReportSettings) Creates an XML report of the changes that have been made to a registered database since it was last registered.
Addin from Cake.SqlPackage.dll

Export

SqlPackageExport(ICakeContext, Action<SqlPackageExportSettings>) Exports a live database to a BACPAC package (.bacpac file).
Addin from Cake.SqlPackage.dll
SqlPackageExport(ICakeContext, SqlPackageExportSettings) Exports a live database to a BACPAC package (.bacpac file).
Addin from Cake.SqlPackage.dll

Extract

SqlPackageExtract(ICakeContext, Action<SqlPackageExtractSettings>) Creates a database snapshot (.dacpac) file from SQL Server.
Addin from Cake.SqlPackage.dll
SqlPackageExtract(ICakeContext, SqlPackageExtractSettings) Creates a database snapshot (.dacpac) file from SQL Server.
Addin from Cake.SqlPackage.dll

Import

SqlPackageImport(ICakeContext, Action<SqlPackageImportSettings>) Imports the schema and table data from a BACPAC package into a new user database
Addin from Cake.SqlPackage.dll
SqlPackageImport(ICakeContext, SqlPackageImportSettings) Imports the schema and table data from a BACPAC package into a new user database
Addin from Cake.SqlPackage.dll

Publish

SqlPackagePublish(ICakeContext, Action<SqlPackagePublishSettings>) Incrementally updates a database schema to match the schema of a source .dacpac file.
Addin from Cake.SqlPackage.dll
SqlPackagePublish(ICakeContext, SqlPackagePublishSettings) Incrementally updates a database schema to match the schema of a source .dacpac file.
Addin from Cake.SqlPackage.dll

Script

SqlPackageScript(ICakeContext, Action<SqlPackageScriptSettings>) Creates a Transact-SQL incremental update script that updates the schema of a target to match the schema of a source.
Addin from Cake.SqlPackage.dll
SqlPackageScript(ICakeContext, SqlPackageScriptSettings) Creates a Transact-SQL incremental update script that updates the schema of a target to match the schema of a source.
Addin from Cake.SqlPackage.dll