DacServices.GenerateDeployScript Method (DacPackage, DacPackage, String, DacDeployOptions)

Creates a Transact-SQL script that can be used to deploy the differences between the schemas of the supplied source and target DacPackage instances to a database.

Namespace:  Microsoft.SqlServer.Dac
Assembly:  Microsoft.SqlServer.Dac (in Microsoft.SqlServer.Dac.dll)

public static string GenerateDeployScript(
	DacPackage sourcePackage,
	DacPackage targetPackage,
	string targetDatabaseName,
	DacDeployOptions options
)

Parameters

sourcePackage
Type: Microsoft.SqlServer.Dac.DacPackage
The DacPackage containing the source schema to be compared.
targetPackage
Type: Microsoft.SqlServer.Dac.DacPackage
The DacPackage containing the target schema to be compared.
targetDatabaseName
Type: String
The name of the target database for deployment.
options
Type: Microsoft.SqlServer.Dac.DacDeployOptions
The instance of DacDeployOptions that specifies properties that affect various aspects of the deployment script creation.

Return Value

Type: String
The string of Transact-SQL script used to create or update database schema based on the supplied DacPackage.

ExceptionCondition
DacServicesException

If a problem occurs during script generation.

Community Additions

Show: