Share via


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

  • targetDatabaseName
    Type: String
    The name of the target database for deployment.

Return Value

Type: String
The 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