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.
命名空间: Microsoft.SqlServer.Dac
程序集: Microsoft.SqlServer.Dac(在 Microsoft.SqlServer.Dac.dll 中)
语法
声明
Public Shared Function GenerateDeployScript ( _
sourcePackage As DacPackage, _
targetPackage As DacPackage, _
targetDatabaseName As String, _
options As DacDeployOptions _
) As String
用法
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
参数
- sourcePackage
类型:Microsoft.SqlServer.Dac.DacPackage
DacPackage containing the source schema to be compared.
- targetPackage
类型:Microsoft.SqlServer.Dac.DacPackage
DacPackage containing the target schema to be compared.
- targetDatabaseName
类型:System.String
Name of the target database for deployment.
- options
类型:Microsoft.SqlServer.Dac.DacDeployOptions
Instance of DacDeployOptions that specifies properties that affect various aspects of the deployment script creation.
返回值
类型:System.String
String of Transact-SQL script used to create or update database schema based on the supplied DacPackage.
异常
异常 | 条件 |
---|---|
DacServicesException | If a problem occurs during script generation. |