Método DacServices.GenerateDeployScript (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 (em Microsoft.SqlServer.Dac.dll)
Sintaxe
'Declaração
Public Shared Function GenerateDeployScript ( _
sourcePackage As DacPackage, _
targetPackage As DacPackage, _
targetDatabaseName As String, _
options As DacDeployOptions _
) As String
'Uso
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
Parâmetros
- sourcePackage
Tipo: Microsoft.SqlServer.Dac.DacPackage
DacPackage containing the source schema to be compared.
- targetPackage
Tipo: Microsoft.SqlServer.Dac.DacPackage
DacPackage containing the target schema to be compared.
- targetDatabaseName
Tipo: System.String
Name of the target database for deployment.
- options
Tipo: Microsoft.SqlServer.Dac.DacDeployOptions
Instance of DacDeployOptions that specifies properties that affect various aspects of the deployment script creation.
Valor de retorno
Tipo: System.String
String of Transact-SQL script used to create or update database schema based on the supplied DacPackage.
Exceções
Exceção | Condição |
---|---|
DacServicesException | If a problem occurs during script generation. |