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)

Syntax

'Declaration
Public Shared Function GenerateDeployScript ( _
    sourcePackage As DacPackage, _
    targetPackage As DacPackage, _
    targetDatabaseName As String, _
    options As DacDeployOptions _
) As String
'Usage
Dim sourcePackage As DacPackage 
Dim targetPackage As DacPackage 
Dim targetDatabaseName As String 
Dim options As DacDeployOptions 
Dim returnValue As String 

returnValue = DacServices.GenerateDeployScript(sourcePackage, _
    targetPackage, targetDatabaseName, _
    options)

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

public:
static String^ GenerateDeployScript(
    DacPackage^ sourcePackage, 
    DacPackage^ targetPackage, 
    String^ targetDatabaseName, 
    DacDeployOptions^ options
)

static member GenerateDeployScript : 
        sourcePackage:DacPackage * 
        targetPackage:DacPackage * 
        targetDatabaseName:string * 
        options:DacDeployOptions -> string

public static function GenerateDeployScript(
    sourcePackage : DacPackage, 
    targetPackage : DacPackage, 
    targetDatabaseName : String, 
    options : DacDeployOptions
) : String

Parameters

• sourcePackage
  Type: Microsoft.SqlServer.Dac.DacPackage
  DacPackage containing the source schema to be compared.

• targetPackage
  Type: Microsoft.SqlServer.Dac.DacPackage
  DacPackage containing the target schema to be compared.

• targetDatabaseName
  Type: System.String
  Name of the target database for deployment.

• options
  Type: Microsoft.SqlServer.Dac.DacDeployOptions
  Instance of DacDeployOptions that specifies properties that affect various aspects of the deployment script creation.

Return Value

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

Exceptions

Exception	Condition
DacServicesException	If a problem occurs during script generation.

See Also

Reference

DacServices Class

GenerateDeployScript Overload

Microsoft.SqlServer.Dac Namespace