Microsoft.SqlServer.Management.Dac 名前空間

The Microsoft.SqlServer.Management.Dac namespace contains classes that represent the Dac objects. The top-level instance is called DacStore and provides the connection to SQL Server. The Dac objects can be used to create and manage a DAC package, which contains all the information required to re-create a data-tier application.

The Microsoft.SqlServer.Management.Dac namespace contains the DAC objects. The DAC objects are used together with the Microsoft.SqlServer.Managment.Smo, Microsoft.SqlServer.Managment.Dmf, and Microsoft.SqlServer.Managment.Utility namespaces to create DAC packages. The DAC packages can be installed on an instance of SQL Server using the DAC object model, or deployed onto the SQL Server Utility using the SQL Server Utility object model. In Design mode, SMO is not connected to an instance of SQL Server. The SMO objects are used to design a data-tier application structure which can be saved into the DAC package. A DAC package can also include a limited amount of reference data and some miscellaneous files. Policy information is stored for each SMO instance class, and for the overall instance of SQL Server using DMF conditions. After it is created, the DAC package can be used to install the data-tier application on an instance of SQL Server that meets the specified DMF conditions. In connected mode, the SMO Server object represents an instance of SQL Server.

The Microsoft.SqlServer.Management.Dac namespace resides in the Microsoft.SqlServer.Management.Dac.dll file. Additionally, some of the enumeration classes are in the Microsoft.SqlServer.Management.DacEnum.dll files. You must import both files to access the classes in the Microsoft.SqlServer.Management.Dac namespace. In addition, you must import the Microsoft.SqlServer.Managment.Smo, Microsoft.SqlServer.Managment.Dmf, and Microsoft.SqlServer.Managment.Sdk.Sfc namespaces to create a DAC package.

By using the Microsoft.SqlServer.Management.Dac namespace, you can do the following:

  • Create an object graph that represents the data-tier application structure.

  • Add reference data.

  • Add miscellaneous files

  • Add deployment conditions.

  • Add configuration conditions.

  • Install the DAC package.

  • Upgrade a DAC package.

  • Create a DAC package.

  • Load and save a DAC package from file (serialize and deserialize).

クラス

  クラス 説明
パブリック クラス ActionNotSupportedException The exception that is thrown when the requested data-tier action, such as upgrade or register, is not supported by the version of the Database Engine the application is connected to.
パブリック クラス BacpacException Represents the error occurred during bacpac operation.
パブリック クラス BinarySourceBase The BinarySourceBase type is a base class that provides access to the IBinarySource interface.
パブリック クラス ConnectionNotSetException The ConnectionNotSetException class is used to raise an exception when the connection passed to a DAC action, such as install, upgrade, or uninstall.
パブリック クラス DacActionEventArgs Represents the data sent when an event is raised by a DAC action step during both deployment and uninstall.
パブリック クラス DacActionValidator Validates that the requirements of the DAC action (install, upgrade, or uninstall) are in place.
パブリック クラス DacCompilationError The Microsoft.SqlServer.Management.Dac.CompilationError class represents an error generated when the DAC package is being compiled.
パブリック クラス DacCompilationErrorCollection The DacCompilationErrorCollection type stores a collection of DAC compilation errors.
パブリック クラス DacCompilationResult The DacCompilationResult class represents the DAC package and the collection of errors generated by compiling it.
パブリック クラス DacCompilationUnit The DacCompilationUnit accepts Transact-SQL content and compiles it into a data-tier application (DAC) type. Any Transact-SQL file can be added or removed prior to compilation. 
パブリック クラス DacConfig Represents the data-tier application (DAC) configuration information.
パブリック クラス DacDatabaseInformation The DacDatabaseInformation object stores information about data-tier application (DAC) actions that can be performed on a database.
パブリック クラス DacDomain The DacDomain class instantiates the Microsoft.SqlServer.Management.Sdk.Sfc methods and properties inherited by the DacStore class.
パブリック クラス DacDomain.Key Contains the key that identifies the DacDomain class.
パブリック クラス DacException The DacException class is a generic exception that is raised when an error occurs using the Microsoft.SqlServer.Management.Dac namespace.
パブリック クラス DacExtractionException The DacExtractionException class is a an exception that is raised when an error occurs during extraction of a DAC package.
パブリック クラス DacExtractionUnit The DacExtractionUnit class contains the information that must be extracted to a DAC type, such as server graphs and miscellaneous files.
パブリック クラス DacExtractValidationResult The DacExtractValidationResult object represents the result of extracting objects from a DAC package.
パブリック クラス DacInstance The DacInstance type stores metadata information, such as the instance name and date created, about a deployed instance of a data-tier application (DAC).
パブリック クラス DacInstance.Key The DacInstance.Key class represents the key that identifies the DacInstance class.
パブリック クラス DacInstanceCollection The DacInstanceCollection type stores one or more DAC instances contained in an instance of the Database Engine.
パブリック クラス DacLogEntry Provides the format for log entries coming from DAC framework.
パブリック クラス DacServerInformation Specifies the level of support for data-tier application (DAC) operations, such as upgrade, in an instance of the Database Engine.
パブリック クラス DacStore The root class of the DAC Domain. The Main role of this class is to store the connection and interact with the SFC framework for most of the services.
パブリック クラス DacType The DacType class represents the set of data-tier objects, policies, and properties developed and deployed to support a specific application.
パブリック クラス DacUpgradeOptions Use the Microsoft.SqlServer.Management.Dac.DacUpgrade type to specify which options are taken when upgrading a DAC instance.
パブリック クラス DacUpgradeResult The DacUpgradeResult class records information about the results of upgrading a DAC instance.
パブリック クラス DatabaseConfigurationProperties
パブリック クラス DatabaseDeploymentProperties The DatabaseDeploymentProperties object represents the properties of a deployed database.
パブリック クラス DatabaseExtractValidator Validates that the database can be extracted.
パブリック クラス DeploymentValidationException The DeploymentValidationException class represents an exception thrown during DAC deployment due to a validation error.
パブリック クラス DesignModeServerExtractException The DesignModeServerExtractException class represents an exception that is raised the server containing the database specified in an extract operation is in Design mode.
パブリック クラス ExtractValidationException The ExtractValidationException class represents an exception thrown during a validation operation.
パブリック クラス FailedTargetSelectionException The FailedTargetSelectionException class represents an exception that is thrown when target selection policy fails during deployment of a DAC.
パブリック クラス FileExtraSource The Microsoft.SqlServer.Management.Dac.FileSource type represents a miscellaneous file that is included in the DAC package.
パブリック クラス InvalidaDACTypeCredentialsException The Microsoft.SqlServer.Management.Dac.InvalidDacTypeCredentialsException class is an exception that is raised when upgrading a DAC if the credentials of the new DAC type do not match the credentials of the current DAC instance.
パブリック クラス InvalidaDatabaseStateException The Microsoft.SqlServer.Management.Dac.InvalidDatabaseStateException class is an exception that is raised when a database is in a state that cannot support a requested data-tier application (DAC) action, such as deploy or upgrade.
パブリック クラス InvalidDatabaseExtractException The Microsoft.SqlServer.Management.Dac.DatabaseExtractException class is an exception that is raised when the database specified in an extract operation is invalid.
パブリック クラス InvalidDatabaseStateForExtractException The Microsoft.SqlServer.Management.Dac.DatabaseExtractException class is an exception that is raised when the database state prevents an extraction operation.
パブリック クラス InvalidInputException The InvalidInputException class is raised when validation of input data fails in the DAC package.
パブリック クラス MiscellaneousFilesCollection The MiscellaneousFilesCollection class contains a collection of files to be added to the DAC package.
パブリック クラス MissingDacSchemaException The MissingDacSchemaException class is an exception that is raised during validation when the DAC schema is missing.
パブリック クラス MissingExtractServerPermissionsException Represents an exception that is raised during extraction when the caller has insufficient permissions on the server to extract the database.
パブリック クラス MissingServerPermissionsException The MissingServerPermissionsException class represents an exception that is raised when the caller has insufficient permissions on the server to deploy the DAC.
パブリック クラス MissingServerPermissionsForRePartException The MissingServerPermissionsForRePartException class represents an exception that is raised when the caller does not have sufficient permissions
パブリック クラス ServerDeploymentValidator Validates that the specified database engine is able to be used as a DAC store.
パブリック クラス SourceInfo The Microsoft.SqlServer.Management.DAC.SourceInfo class represents a location in a DAC source file that has thrown an exception.
パブリック クラス TableName
パブリック クラス TSqlCompilationException The TSqlCompilationException class represents an exception that is thrown during Transact-SQL compilation.
パブリック クラス TSqlSourceFile The TSqlSourceFile class represents a Transact-SQL source file.
パブリック クラス UserLoginMapping Represents a collection of user login maps.
パブリック クラス ValidatedObject The ValidatedObject class describes objects that have been validated.
パブリック クラス ValidatedObjectEventArgs Represents an object that was validated as part of a data-tier application (DAC) action, such as deploy or delete.

構造体

  構造体 説明
パブリック構造体 Location Represents the location of the source of the error in the Transact-SQL input files to the DAC compilation unit.
パブリック構造体 UserLoginMap Represents a mapping between user and login.

インターフェイス

  インターフェイス 説明
パブリック インターフェイス IBinarySource The IBinarySource type is an interface that provides access to an I/O file stream.
パブリック インターフェイス IExtraSource The IExtraSource type is an interface that provides I/O stream access to a miscellaneous file in the DAC package.
パブリック インターフェイス ISizeItem Defines an interface that allows the implementing class to calculate its size.

列挙体

  列挙体 説明
パブリック列挙体 ActionName The ActionName enumeration lists the names of each possible action step.
パブリック列挙体 ActionState The ActionState enumeration lists the possible DAC action step states.
パブリック列挙体 AzureEdition Specifies the azure edition used.
パブリック列挙体 DacExceptionType The DacExceptionType enumeration contains values that are used to specify the type of DAC exception.
パブリック列挙体 DacUninstallMode The DacUninstallMode enumeration contains values that are used to specify what to do with the database associated with a DAC instance when the instance is uninstalled.
パブリック列挙体 DatabaseState Enumerates the possible states of the DAC database.
パブリック列挙体 MessageLevel Enumerates the DAC message level.
パブリック列挙体 ObjectValidationResult An enumeration that specifies the values for reporting the results of validating or extracting an object.