DacServices DacServices DacServices Class

Definition

Provides operations to create and consume DAC packages represented by DacPackage instances.

public sealed class DacServices
type DacServices = class
Public NotInheritable Class DacServices
Inheritance
DacServicesDacServicesDacServices

Constructors

DacServices(String) DacServices(String) DacServices(String)

Construct a new instance of the DacServices class that operates against the database specified by the supplied connection string.

DacServices(String, IUniversalAuthProvider) DacServices(String, IUniversalAuthProvider) DacServices(String, IUniversalAuthProvider)

Construct a new instance of the DacServices class that operates against the database specified by the supplied connection string and authentication provider.

DacServices(String, SecureString) DacServices(String, SecureString) DacServices(String, SecureString)

Construct a new instance of the DacServices class that operates against the database specified by the supplied connection string.

Methods

Deploy(DacPackage, String, Boolean, DacDeployOptions, Nullable<CancellationToken>) Deploy(DacPackage, String, Boolean, DacDeployOptions, Nullable<CancellationToken>) Deploy(DacPackage, String, Boolean, DacDeployOptions, Nullable<CancellationToken>)

Deploy the supplied package to a database.

ExportBacpac(Stream, String, IEnumerable<Tuple<String,String>>, Nullable<CancellationToken>) ExportBacpac(Stream, String, IEnumerable<Tuple<String,String>>, Nullable<CancellationToken>) ExportBacpac(Stream, String, IEnumerable<Tuple<String,String>>, Nullable<CancellationToken>)

Extract schema and export data from a database into a "bacpac" package.

ExportBacpac(String, String, IEnumerable<Tuple<String,String>>, Nullable<CancellationToken>) ExportBacpac(String, String, IEnumerable<Tuple<String,String>>, Nullable<CancellationToken>) ExportBacpac(String, String, IEnumerable<Tuple<String,String>>, Nullable<CancellationToken>)

Extract schema and export data from a database into a "bacpac" package.

ExportBacpac(Stream, String, DacExportOptions, IEnumerable<Tuple<String,String>>, Nullable<CancellationToken>) ExportBacpac(Stream, String, DacExportOptions, IEnumerable<Tuple<String,String>>, Nullable<CancellationToken>) ExportBacpac(Stream, String, DacExportOptions, IEnumerable<Tuple<String,String>>, Nullable<CancellationToken>)

Extract schema and export data from a database into a "bacpac" package.

ExportBacpac(Stream, String, DacSchemaModelStorageType, IEnumerable<Tuple<String,String>>, Nullable<CancellationToken>) ExportBacpac(Stream, String, DacSchemaModelStorageType, IEnumerable<Tuple<String,String>>, Nullable<CancellationToken>) ExportBacpac(Stream, String, DacSchemaModelStorageType, IEnumerable<Tuple<String,String>>, Nullable<CancellationToken>)

Extract schema and export data from a database into a "bacpac" package.

ExportBacpac(String, String, DacExportOptions, IEnumerable<Tuple<String,String>>, Nullable<CancellationToken>) ExportBacpac(String, String, DacExportOptions, IEnumerable<Tuple<String,String>>, Nullable<CancellationToken>) ExportBacpac(String, String, DacExportOptions, IEnumerable<Tuple<String,String>>, Nullable<CancellationToken>)

Extract schema and export data from a database into a "bacpac" package.

ExportBacpac(String, String, DacSchemaModelStorageType, IEnumerable<Tuple<String,String>>, Nullable<CancellationToken>) ExportBacpac(String, String, DacSchemaModelStorageType, IEnumerable<Tuple<String,String>>, Nullable<CancellationToken>) ExportBacpac(String, String, DacSchemaModelStorageType, IEnumerable<Tuple<String,String>>, Nullable<CancellationToken>)

Extract schema and export data from a database into a "bacpac" package.

Extract(Stream, String, String, Version, String, IEnumerable<Tuple<String,String>>, DacExtractOptions, Nullable<CancellationToken>) Extract(Stream, String, String, Version, String, IEnumerable<Tuple<String,String>>, DacExtractOptions, Nullable<CancellationToken>) Extract(Stream, String, String, Version, String, IEnumerable<Tuple<String,String>>, DacExtractOptions, Nullable<CancellationToken>)

Extract the schema from a database into a package.

Extract(String, String, String, Version, String, IEnumerable<Tuple<String,String>>, DacExtractOptions, Nullable<CancellationToken>) Extract(String, String, String, Version, String, IEnumerable<Tuple<String,String>>, DacExtractOptions, Nullable<CancellationToken>) Extract(String, String, String, Version, String, IEnumerable<Tuple<String,String>>, DacExtractOptions, Nullable<CancellationToken>)

Extract the schema from a database into a package.

GenerateCreateScript(DacPackage, String, DacDeployOptions) GenerateCreateScript(DacPackage, String, DacDeployOptions) GenerateCreateScript(DacPackage, String, DacDeployOptions)

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

GenerateCreateScript(Stream, DacPackage, String, DacDeployOptions) GenerateCreateScript(Stream, DacPackage, String, DacDeployOptions) GenerateCreateScript(Stream, DacPackage, String, DacDeployOptions)

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

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

Create XML report of the steps needed to deploy the schema of the supplied DacPackage to a database.

GenerateDeployReport(Stream, DacPackage, DacPackage, String, DacDeployOptions) GenerateDeployReport(Stream, DacPackage, DacPackage, String, DacDeployOptions) GenerateDeployReport(Stream, DacPackage, DacPackage, String, DacDeployOptions)

Create XML report of the steps needed to deploy the differences between the schemas of the supplied source and target DacPackage instances to a database.

GenerateDeployReport(DacPackage, DacPackage, String, DacDeployOptions) GenerateDeployReport(DacPackage, DacPackage, String, DacDeployOptions) GenerateDeployReport(DacPackage, DacPackage, String, DacDeployOptions)

Create XML report of the steps needed to deploy the differences between the schemas of the supplied source and target DacPackage instances to a database.

GenerateDeployScript(DacPackage, DacPackage, String, DacDeployOptions) GenerateDeployScript(DacPackage, DacPackage, String, DacDeployOptions) 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>) GenerateDeployScript(DacPackage, String, DacDeployOptions, Nullable<CancellationToken>) 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) GenerateDeployScript(Stream, DacPackage, DacPackage, String, DacDeployOptions) 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.

GenerateDriftReport(String, Nullable<CancellationToken>) GenerateDriftReport(String, Nullable<CancellationToken>) GenerateDriftReport(String, Nullable<CancellationToken>)

Create XML report of the drift that has occurred since the database was last registered.

GenerateDriftReport(String, DacSchemaModelStorageType, Nullable<CancellationToken>) GenerateDriftReport(String, DacSchemaModelStorageType, Nullable<CancellationToken>) GenerateDriftReport(String, DacSchemaModelStorageType, Nullable<CancellationToken>)

Create XML report of the drift that has occurred since the database was last registered.

ImportBacpac(BacPackage, String, DacImportOptions, Nullable<CancellationToken>) ImportBacpac(BacPackage, String, DacImportOptions, Nullable<CancellationToken>) ImportBacpac(BacPackage, String, DacImportOptions, Nullable<CancellationToken>)

Deploy schema and import table data from the supplied package to a database.

ImportBacpac(BacPackage, String, Nullable<CancellationToken>) ImportBacpac(BacPackage, String, Nullable<CancellationToken>) ImportBacpac(BacPackage, String, Nullable<CancellationToken>)

Deploy schema and import table data from the supplied package to a database.

ImportBacpac(BacPackage, String, DacAzureDatabaseSpecification, Nullable<CancellationToken>) ImportBacpac(BacPackage, String, DacAzureDatabaseSpecification, Nullable<CancellationToken>) ImportBacpac(BacPackage, String, DacAzureDatabaseSpecification, Nullable<CancellationToken>)

Deploy schema and import table data from the supplied package to a database.

Publish(DacPackage, String, PublishOptions) Publish(DacPackage, String, PublishOptions) Publish(DacPackage, String, PublishOptions)

Publish the supplied package to a database. This method supports returning the script used when publishing along with a deployment report summarizing the actions taken during Publish

Register(String, String, Version, String) Register(String, String, Version, String) Register(String, String, Version, String)

Add DAC registration information for the specified target database.

Register(String, DacSchemaModelStorageType, String, Version, String) Register(String, DacSchemaModelStorageType, String, Version, String) Register(String, DacSchemaModelStorageType, String, Version, String)

Add DAC registration information for the specified target database.

Script(DacPackage, DacPackage, String, PublishOptions) Script(DacPackage, DacPackage, String, PublishOptions) Script(DacPackage, DacPackage, String, PublishOptions)

Scripts the steps for a publish operation as a deployment script, deployment report, or both. At least one of the GenerateDeploymentScript or GenerateDeploymentReport options must be set to true. This method will not modify the target

Script(DacPackage, String, PublishOptions) Script(DacPackage, String, PublishOptions) Script(DacPackage, String, PublishOptions)

Scripts the steps for a publish operation as a deployment script, deployment report, or both. At least one of the GenerateDeploymentScript or GenerateDeploymentReport options must be set to true. This method will not publish to the database

Unregister(String) Unregister(String) Unregister(String)

Remove DAC registration information for the specified target database.

Events

Message Message Message

Invoked as an operation reports status updates or errors.

ProgressChanged ProgressChanged ProgressChanged

Invoked as the state of an operation changes.

Applies to