DacServices.GenerateDeployScript Method

  • Reference

Definition

Namespace:
Microsoft.SqlServer.Dac
Assembly:
Microsoft.SqlServer.Dac.dll
Package:
Microsoft.SqlServer.DacFx.x64 v140.3881.1
Package:
Microsoft.SqlServer.DacFx v150.5282.3
Package:
Microsoft.SqlServer.DacFx v160.6161.0
Package:
Microsoft.SqlServer.DacFx v162.2.111
Package:
Microsoft.Data.Tools.Msbuild v10.0.61804.210

Overloads

GenerateDeployScript(DacPackage, DacPackage, String, DacDeployOptions)

Create T-SQL script that can be used to deploy the differences between the schemas of the supplied source and target DacPackage instances to a database.
GenerateDeployScript(DacPackage, String, DacDeployOptions, Nullable<CancellationToken>)

Create T-SQL script that can be used to deploy the schema of the supplied DacPackage to a database.
GenerateDeployScript(Stream, DacPackage, DacPackage, String, DacDeployOptions)

Create T-SQL script that can be used to deploy the differences between the schemas of the supplied source and target DacPackage instances to a database.

GenerateDeployScript(DacPackage, DacPackage, String, DacDeployOptions)

Create T-SQL script that can be used to deploy the differences between the schemas of the supplied source and target DacPackage instances to a database.

public static string GenerateDeployScript (Microsoft.SqlServer.Dac.DacPackage sourcePackage, Microsoft.SqlServer.Dac.DacPackage targetPackage, string targetDatabaseName, Microsoft.SqlServer.Dac.DacDeployOptions options = default);
static member GenerateDeployScript : Microsoft.SqlServer.Dac.DacPackage * Microsoft.SqlServer.Dac.DacPackage * string * Microsoft.SqlServer.Dac.DacDeployOptions -> string
Public Shared Function GenerateDeployScript (sourcePackage As DacPackage, targetPackage As DacPackage, targetDatabaseName As String, Optional options As DacDeployOptions = Nothing) As String

Parameters

sourcePackage
DacPackage

DacPackage containing the source schema to be compared.

targetPackage
DacPackage

DacPackage containing the target schema to be compared.

targetDatabaseName
String

Name of the target database for deployment.

options
DacDeployOptions

Instance of DacDeployOptions that specifies properties that affect various aspects of the deployment script creation.

Returns

String

String of T-SQL script used to create or update database schema based on the supplied DacPackage.

Exceptions

DacServicesException

If a problem occurs during script generation.

Applies to

GenerateDeployScript(DacPackage, String, DacDeployOptions, Nullable<CancellationToken>)

Create T-SQL script that can be used to deploy the schema of the supplied DacPackage to a database.

public string GenerateDeployScript (Microsoft.SqlServer.Dac.DacPackage package, string targetDatabaseName, Microsoft.SqlServer.Dac.DacDeployOptions options = default, System.Threading.CancellationToken? cancellationToken = default);
member this.GenerateDeployScript : Microsoft.SqlServer.Dac.DacPackage * string * Microsoft.SqlServer.Dac.DacDeployOptions * Nullable<System.Threading.CancellationToken> -> string
Public Function GenerateDeployScript (package As DacPackage, targetDatabaseName As String, Optional options As DacDeployOptions = Nothing, Optional cancellationToken As Nullable(Of CancellationToken) = Nothing) As String

Parameters

package
DacPackage

DacPackage containing schema to be deployed.

targetDatabaseName
String

Name of the target database for deployment.

options
DacDeployOptions

Instance of DacDeployOptions that specifies properties that affect various aspects of the deployment script creation.

cancellationToken
Nullable<CancellationToken>

Optional CancellationToken that can be used to indicate that the operation should be cancelled. Use of this object does not guarantee that the operation will be cancelled.

Returns

String

String of T-SQL script used to create or update database schema based on the supplied DacPackage.

Exceptions

DacServicesException

If a problem occurs during script generation.

OperationCanceledException

If the CancellationToken has a cancellation requested and the operation could be cancelled.

Applies to

GenerateDeployScript(Stream, DacPackage, DacPackage, String, DacDeployOptions)

Create T-SQL script that can be used to deploy the differences between the schemas of the supplied source and target DacPackage instances to a database.

public static void GenerateDeployScript (System.IO.Stream outputStream, Microsoft.SqlServer.Dac.DacPackage sourcePackage, Microsoft.SqlServer.Dac.DacPackage targetPackage, string targetDatabaseName, Microsoft.SqlServer.Dac.DacDeployOptions options = default);
static member GenerateDeployScript : System.IO.Stream * Microsoft.SqlServer.Dac.DacPackage * Microsoft.SqlServer.Dac.DacPackage * string * Microsoft.SqlServer.Dac.DacDeployOptions -> unit
Public Shared Sub GenerateDeployScript (outputStream As Stream, sourcePackage As DacPackage, targetPackage As DacPackage, targetDatabaseName As String, Optional options As DacDeployOptions = Nothing)

Parameters

outputStream
Stream

Stream to which to write the deployment script.

sourcePackage
DacPackage

DacPackage containing the source schema to be compared.

targetPackage
DacPackage

DacPackage containing the target schema to be compared.

targetDatabaseName
String

Name of the target database for deployment.

options
DacDeployOptions

Instance of DacDeployOptions that specifies properties that affect various aspects of the deployment script creation.

Exceptions

DacServicesException

If a problem occurs during script generation.

Applies to