Méthode 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.
Espace de noms : Microsoft.SqlServer.Dac
Assembly : Microsoft.SqlServer.Dac (en Microsoft.SqlServer.Dac.dll)
Syntaxe
'Déclaration
Public Shared Function GenerateDeployScript ( _
sourcePackage As DacPackage, _
targetPackage As DacPackage, _
targetDatabaseName As String, _
options As DacDeployOptions _
) As String
'Utilisation
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
Paramètres
- 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.
Valeur de retour
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. |