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
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.
Exceptions
| Exception | Condition |
|---|---|
| DacServicesException | If a problem occurs during script generation. |