DacServices Class

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

Inheritance Hierarchy

System.Object
  Microsoft.SqlServer.Dac.DacServices

Namespace:  Microsoft.SqlServer.Dac
Assembly:  Microsoft.SqlServer.Dac (in Microsoft.SqlServer.Dac.dll)

Syntax

'Declaration
Public NotInheritable Class DacServices
'Usage
Dim instance As DacServices
public sealed class DacServices
public ref class DacServices sealed
[<SealedAttribute>]
type DacServices =  class end
public final class DacServices

The DacServices type exposes the following members.

Constructors

  Name Description
Public method DacServices Initializes a new instance of the DacServices class that operates against the database specified by the supplied connection string.

Top

Methods

  Name Description
Public method Deploy Deploys the supplied package to a database.
Public method Equals (Inherited from Object.)
Public method ExportBacpac(Stream, String, IEnumerable<Tuple<String, String>>, Nullable<CancellationToken>) Extracts schema and export data from a database into a "bacpac" package.
Public method ExportBacpac(String, String, IEnumerable<Tuple<String, String>>, Nullable<CancellationToken>) Extracts schema and export data from a database into a "bacpac" package.
Public method ExportBacpac(Stream, String, DacSchemaModelStorageType, IEnumerable<Tuple<String, String>>, Nullable<CancellationToken>) Extracts schema and export data from a database into a "bacpac" package.
Public method ExportBacpac(String, String, DacSchemaModelStorageType, IEnumerable<Tuple<String, String>>, Nullable<CancellationToken>) Extracts schema and export data from a database into a "bacpac" package.
Public method Extract(Stream, String, String, Version, String, IEnumerable<Tuple<String, String>>, DacExtractOptions, Nullable<CancellationToken>) Extracts the schema from a database into a package.
Public method Extract(String, String, String, Version, String, IEnumerable<Tuple<String, String>>, DacExtractOptions, Nullable<CancellationToken>) Extracts the schema from a database into a package.
Public methodStatic member GenerateCreateScript(DacPackage, String, DacDeployOptions) Creates a Transact-SQL script that can be used to deploy the schema of the supplied DacPackage to a database.
Public methodStatic member GenerateCreateScript(Stream, DacPackage, String, DacDeployOptions) Creates a Transact-SQL script that can be used to deploy the schema of the supplied DacPackage to a database.
Public methodStatic member GenerateDeployReport(DacPackage, DacPackage, String, DacDeployOptions) Creates an XML report of the steps needed to deploy the differences between the schemas of the supplied source and target DacPackage instances to a database.
Public method GenerateDeployReport(DacPackage, String, DacDeployOptions, Nullable<CancellationToken>) Creates an XML report of the steps needed to deploy the schema of the supplied DacPackage to a database.
Public methodStatic member GenerateDeployReport(Stream, DacPackage, DacPackage, String, DacDeployOptions) Creates an XML report of the steps needed to deploy the differences between the schemas of the supplied source and target DacPackage instances to a database.
Public methodStatic member 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.
Public method GenerateDeployScript(DacPackage, String, DacDeployOptions, Nullable<CancellationToken>) Creates a Transact-SQL script that can be used to deploy the schema of the supplied DacPackage to a database.
Public methodStatic member GenerateDeployScript(Stream, 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.
Public method GenerateDriftReport(String, Nullable<CancellationToken>) Creates an XML report of the drift that has occurred since the database was last registered.
Public method GenerateDriftReport(String, DacSchemaModelStorageType, Nullable<CancellationToken>) Creates an XML report of the drift that has occurred since the database was last registered.
Public method GetHashCode (Inherited from Object.)
Public method GetType (Inherited from Object.)
Public method ImportBacpac(BacPackage, String, Nullable<CancellationToken>) Deploys schema and import table data from the supplied package to a database.
Public method ImportBacpac(BacPackage, String, DacAzureDatabaseSpecification, Nullable<CancellationToken>) Deploys schema and import table data from the supplied package to a database.
Public method Register(String, String, Version, String) Adds DAC registration information for the specified target database.
Public method Register(String, DacSchemaModelStorageType, String, Version, String) Adds DAC registration information for the specified target database.
Public method ToString (Inherited from Object.)
Public method Unregister Removes DAC registration information for the specified target database.

Top

Events

  Name Description
Public event Message Invoked when an operation reports status updates or errors.
Public event ProgressChanged Invoked when the state of an operation changes.

Top

Thread Safety

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

See Also

Reference

Microsoft.SqlServer.Dac Namespace