Microsoft.SqlServer.Dac.Deployment Namespace

  • Article

Classes

  Class Description
Public class AlterElementStep A step in a deployment plan that represent an alter to an element. This class is for read-only purpose and cannot be instantiated.
Public class BeginPostDeploymentScriptStep A step in the deployment plan that represents script deployment at the beginning the post-deployment. This class is for read-only purpose and cannot be instantiated.
Public class BeginPreDeploymentScriptStep A step in the deployment plan that represents script deployment at the beginning of pre-deployment. This class is for read-only purpose and cannot be instantiated.
Public class BuildContributor Represents the base class for build contributors. Subclasses of this class participate in a build by modifying a project model or by executing the model.
Public class BuildContributorContext Provides the context for the build process that is used by BuildContributor objects during project build. See documentation for the Arguments and ExtensionFiles properties for information on how to specify these inside a project file.
Public class BuildFailedException Represents a BuildFailedException should be thrown to indicate that the build cannot continue. This will stop the build process.
Public class ContributorArgumentConfiguration Instances of this class are created by Build and Deployment contributors during design-time to initialize arguments that are passed to them at runtime. In SSDT, these arguments must be specified using a ContributorArguments property in a .sqlproj file or a referenced .targets file. For instance to add a "RunMyContributor" argument with a value of "true", the following would be added: <PropertyGroup> <ContributorArguments Condition="'$(Configuration)' == 'Debug''"> $(ContributorArguments);RunMyContributor=True; </ContributorArguments> </PropertyGroup>In this case the argument is only added for Debug configuration. Using the above configuration it is possible to collect information from the MSBuild environment and pass it to the contributor. It is also possible to specify these when creating a package by using BuildPackage(String, TSqlModel, PackageMetadata, PackageOptions) and specifying PackageOptions.
Public class CreateElementStep The step in a deployment plan that represents a create of an element. This class is for read-only purpose and cannot be instantiated.
Public class DacBulkCopyStep The DacBulkCopyStep uploads / streams data from the dac package to the target db. This class is for read-only purpose and cannot be instantiated.
Public class DacDeleteFromTablesStep The step in deployment plan that represents delete from table. This class is for read-only purpose and cannot be instantiated.
Public class DacDisableForeignKeysStep The step in deployment plan that represents disabling foreign keys. This class is for read-only purpose and cannot be instantiated.
Public class DacRestoreConstraintsStep The step in deployment plan that represents restoring constraints. This class is for read-only purpose and cannot be instantiated.
Public class DacSaveConstraintsStep The step in deployment plan that represents saving constraints. This class is for read-only purpose.
Public class DeploymentContributor Represents the base class for deployment contributors. Subclasses of this class participate in a deployment by modifying a deployment plan or by executing the plan.
Public class DeploymentContributorConfigurationSetup Represents the current setup for DeploymentContributor objects. The setup object can be used by deployment contributors during build operations to cause files to be copied as outputs that are stored in the generated dacpac, or to create new files that are stored in the dacpac. See the DeploymentContributorConfigurationStream API for more information about specifying inputs.
Public class DeploymentContributorConfigurationStream Represents a streamable version of a configuration file that is used by DacFx in the deployment and build processes. These streams enable deployment extensions to enhance and extend the design and deployment experience. Input configuration files can be defined in a .sqlproj file as part of the MSBuild process. The files are treated as streams, and will be passed to contributors via the EstablishDeploymentConfiguration(DeploymentContributorConfigurationSetup) method, where they can be copied as outputs that are stored in the generated dacpac. These streams will then be made available in the ApplyDeploymentConfiguration(DeploymentContributorContext, ICollectionDeploymentContributorConfigurationStream), where they can be consumed for configuration and data during deployment. At the end of the ApplyDeploymentConfiguration(DeploymentContributorContext, ICollectionDeploymentContributorConfigurationStream) method all streams will be disposed. Contributors that need to obtain data from the streams must read and cache the data during this method - attempts to read from the stream during the OnExecute(DeploymentPlanContributorContext) method will fail. Inside a .sqproj file, Deployment Configuration files are specified as follows: <ItemGroup> <DeploymentExtensionConfiguration Include="MyContributorName.MyFileName1.sql" /> <DeploymentExtensionConfiguration Include="MyContributorName.MyFileName2.sql" /> </ItemGroup>Note that configuration streams are accessible to all contributors. Contributors may employ a file naming pattern to identify which input files related to that contributor.
Public class DeploymentContributorContext Provides a context for DeploymentContributor objects in DacFx
Public class DeploymentContributorInformation Provides information that identifies a deployment contributor.
Public class DeploymentFailedException Represents an exception that occurs during deployment.
Public class DeploymentPlan Represents the plan that is generated for Deployment.
Public class DeploymentPlanContributor Represents a contributor to the deployment process.
Public class DeploymentPlanContributorContext Provides a context for DeploymentPlanContributor objects.
Public class DeploymentPlanExecutor Represents a deployment constributor that executes the deployment plan. An example of a constributor would be one who executes deployment steps to create a report about actions performed during a deployment.
Public class DeploymentPlanHandle Represents the plan to handle the deployment.
Public class DeploymentPlanModifier Represents a constributor that can modify a deployment plan.
Public class DeploymentScriptDomStep Base class for script based deployment steps. Represents a deployment step that consists of an Abstract Syntax Tree (AST) and reference to a script Domain Object Model (DOM) generator. This class is for read-only purpose.
Public class DeploymentScriptStep Represents the step in deployment plan that represents deploying scripts. This class can be instantiated and used by extensions.
Public class DeploymentStep Represents a step in a deployment plan.
Public class DeploymentStepInternal Base class for implementing deployment step types. It should not be used for writing extensions. Extensions must directly implement DeploymentStep
Public class DropElementStep A step in deployment step that represents dropping a sql object. This class is for read-only purpose and cannot be instantiated.
Public class EmptyStep Represents an empty step in deployment plan. This class is for read-only purpose and cannot be instantiated.
Public class EndPostDeploymentScriptStep A step in the deployment plan that represents script deployment at the end of post-deployment. This class is for read-only purpose and cannot be instantiated.
Public class EndPreDeploymentScriptStep A step in the deployment plan that represents script deployment at the end of pre-deployment. This class is for read-only purpose and cannot be instantiated.
Public class ExportBuildContributorAttribute Represents the concrete classes implementing BuildContributor must add the ExportBuildContributorAttribute attribute to their class definition. This ensures they will be detected and available for use during build. BuildContributors require a unique ID which can be based on their fully qualified type name, or explicitly passed as a string.
Public class ExportDeploymentPlanExecutorAttribute Represents the concrete classes implementing DeploymentPlanExecutor must add the ExportDeploymentPlanExecutorAttribute attribute to their class definition. This ensures they will be detected and available for use during SQL Deployment. DeploymentPlanExecutors require a unique ID which can be based on their fully qualified type name, or explicitly passed as a string.
Public class ExportDeploymentPlanModifierAttribute Represents the concrete classes implementing DeploymentPlanModifier must add the ExportDeploymentPlanModifierAttribute attribute to their class definition. This ensures they will be detected and available for use during SQL Deployment. DeploymentPlanModifiers require a unique ID which can be based on their fully qualified type name, or explicitly passed as a string.
Public class ModelComparisonChangeDefinition Contains change details for a TSqlObject. Including changed properties, added/dropped/ordinal changed relationship entries, added/dropped/changed/ordinal changed composing children and added/dropped/changed/ordinal changed hierarchical children.
Public class ModelComparisonResult SchemaModel compare result. Contains same elements list, elements needed to add to target list, elements needed to drop in target list, and changed elements list.
Public class SqlBeginAltersStep Instances of this class mark the portion of the deployment plan where ALTERs (and CREATEs) are performed. This class is for read-only purpose and cannot be instantiated.
Public class SqlBeginDropsStep An instance of this class marks the beginning of the "drops" portion of the deployment plan. Drops occur in the plan before Alters. This class is for read-only purpose and cannot be instantiated.
Public class SqlBeginPreservationStep This class marks the start (in a deployment plan) of the preservation of intent section of the plan. These operations are ones taken to affect refactoring changes. This class is for read-only purpose and cannot be instantiated.
Public class SqlBeginTransactionStep This step marks the beginning of the transactional section of a deployment plan. This class is for read-only purpose and cannot be instantiated.
Public class SqlChangeDatabaseStep The step in deployment step that represents change database. This class is for read-only purpose and cannot be instantiated.
Public class SqlCreateDatabaseStep The step in deployment that represents database creation. This class is for read-only purpose and cannot be instantiated.
Public class SqlCreateTrackingTableStep The step in deployment that represents the creation of the tracking table (__ScriptTrackingLogs). This table is used to improve the reliability of deployment to SQL Azure. This class is for read-only purpose and cannot be instantiated.
Public class SqlDeploymentOptions Contains deployment options values used for deployment
Public class SqlDropDatabaseStep The step in deployment that represents database drop. This class is for read-only purpose and cannot be instantiated.
Public class SqlDropTrackingTableStep The step in deployment that represents drop of the tracking table (__ScriptTrackingLogs). This class is for read-only purpose and cannot be instantiated.
Public class SqlEndAltersStep Instances of this class mark the portion of the deployment plan where ALTERs (and CREATEs) are completed. This class is for read-only purpose and cannot be instantiated.
Public class SqlEndDropsStep An instance of this class marks the end of the "drops" portion of the deployment plan. This class is for read-only purpose and cannot be instantiated.
Public class SqlEndPreservationStep This class marks the end (in a deployment plan) of the preservation of intent section of the plan. These operations are ones taken to affect refactoring changes. This class is for read-only purpose and cannot be instantiated.
Public class SqlEndTransactionStep This step marks the end of the transactional section of a deployment script. This class is for read-only purpose and cannot be instantiated.
Public class SqlFinalizeDatabaseAccessStep This step is represents a step in the SQL deployment plan that finalizes the access settings to the database. These settings include Read-Only or Read-Write access, restricted, single user or multi-user, and online versus offline. This class is for read-only purpose and cannot be instantiated.
Public class SqlMoveSchemaStep In the deployment plan, instances of this step represent moving the element from a previous schema to the new one. This class is for read-only purpose and cannot be instantiated.
Public class SqlPrintStep A type of step in a Sql deployment plan that signifies a SQL "print" statement. This class is for read-only purpose and cannot be instantiated.
Public class SqlRenameStep Represents a step in the deployment plan that renames a element. This class is for read-only purpose and cannot be instantiated.
Public class SqlTableMigrationStep Represents a data motion step in a sql deployment plan. This class is for read-only purpose and cannot be instantiated.