DacServices Class

SQL Server 2014

Other Versions

SQL Server 2012

Updated: April 20, 2017

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

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

Inheritance Hierarchy

System::Object
Microsoft.SqlServer.Dac::DacServices

Syntax

C++

public ref class DacServices sealed

Constructors

	Name	Description
	DacServices(String^)	Initializes a new instance of the DacServices class that operates against the database specified by the supplied connection string.
	DacServices(String^, IUniversalAuthProvider^)
	DacServices(String^, SecureString^)

Properties

	Name	Description
	DebugDeployScript

Methods

	Name	Description
	Deploy(DacPackage^, String^, Boolean, DacDeployOptions^, Nullable<CancellationToken>)	Deploys the supplied package to a database.
	Equals(Object^)	(Inherited from Object.)
	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>)	Extracts schema and exports data from a database into a "bacpac" package.
	ExportBacpac(Stream^, String^, IEnumerable<Tuple<String^, String^>^>^, Nullable<CancellationToken>)	Extracts schema and exports data from a database into a "bacpac" package.
	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>)	Extracts schema and exports data from a database into a "bacpac" package.
	ExportBacpac(String^, String^, IEnumerable<Tuple<String^, String^>^>^, Nullable<CancellationToken>)	Extracts schema and exports data from a database into a "bacpac" package.
	Extract(Stream^, String^, String^, Version^, String^, IEnumerable<Tuple<String^, String^>^>^, DacExtractOptions^, Nullable<CancellationToken>)	Extracts the schema from a database into a package.
	Extract(String^, String^, String^, Version^, String^, IEnumerable<Tuple<String^, String^>^>^, DacExtractOptions^, Nullable<CancellationToken>)	Extracts the schema from a database into a package.
	GenerateCreateScript(DacPackage^, String^, DacDeployOptions^)	Creates a Transact-SQL script that can be used to deploy the schema of the supplied DacPackage to a database.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	GenerateDriftReport(String^, DacSchemaModelStorageType, Nullable<CancellationToken>)	Creates an XML report of the drift that has occurred since the database was last registered.
	GenerateDriftReport(String^, Nullable<CancellationToken>)	Creates an XML report of the drift that has occurred since the database was last registered.
	GetHashCode()	(Inherited from Object.)
	GetType()	(Inherited from Object.)
	ImportBacpac(BacPackage^, String^, DacAzureDatabaseSpecification^, Nullable<CancellationToken>)	Deploys schema and imports table data from the supplied package to a database.
	ImportBacpac(BacPackage^, String^, DacImportOptions^, Nullable<CancellationToken>)	Deploy schema and import table data from the supplied package to a database.
	ImportBacpac(BacPackage^, String^, Nullable<CancellationToken>)	Deploys schema and imports table data from the supplied package to a database.
	Publish(DacPackage^, String^, PublishOptions^)
	Register(String^, DacSchemaModelStorageType, String^, Version^, String^)	Adds DAC registration information for the specified target database.
	Register(String^, String^, Version^, String^)	Adds DAC registration information for the specified target database.
	Script(DacPackage^, DacPackage^, String^, PublishOptions^)
	Script(DacPackage^, String^, PublishOptions^)
	ToString()	(Inherited from Object.)
	Unregister(String^)	Removes DAC registration information for the specified target database.

Events

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

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.

Community Additions

ADD