Microsoft.Data.Schema.Sql.Build Namespace

  • Article

The Microsoft.Data.Schema.Sql.Build namespace contains SQL plan generation and deployment option classes.

Classes

  Class Description
Public class Sql100SchemaDeploymentOptions Represents deployment options that are specific to SQL Server 2008.
Public class Sql90SchemaDeploymentOptions Represents deployment options that are specific to Microsoft SQL Server 2005.
Public class SqlAlterDataLossError This class represents a warning from the SQL Server deployment engine where the potential for ALTER data loss is identified. The table that is specified in the constructor is the source table.
Public class SqlBeginAltersStep Instances of this class mark the part of the deployment plan where ALTER (and CREATE) actions are performed. This is usually the second half of the plan.
Public class SqlBeginDropsStep An instance of this class marks the start of the DROP action part of the deployment plan. DROP actions occur in the plan before ALTER actions.
Public class SqlBeginPreservationStep This class marks the start (in a deployment plan) of the preservation of intent section of the plan. These operations are used to make refactoring changes.
Public class SqlBeginTransactionStep This step marks the start of the transactional section of a deployment plan.
Public class SqlCreateDataLossError This class represents a warning from the SQL Server deployment engine where the potential for CREATE data loss has been identified. The table that is specified in the constructor is the source table. Usually this error is raised if a new non-nullable column is added to a table without a default.
Public class SqlDeploymentExecutionError This class represents an error that was received by SQL Server when the deployment script was executed.
Public class SqlDropDataLossError This class represents a warning from the SQL Server deployment engine where the potential for DROP data loss has been identified. The table that is specified in the constructor is the target table.
Public class SqlEndAltersStep Instances of this class mark the end of the section of the deployment plan where ALTER (and CREATE) actions are performed.
Public class SqlEndDropsStep An instance of this class marks the end of the DROP action part of the deployment plan.
Public class SqlEndPreservationStep Represents the end of the preservation of intent section of the deployment plan.
Public class SqlEndTransactionStep Represents a step in the SQL Server deployment plan that marks the end of the transactional section of a deployment script.
Public class SqlFinalizeDatabaseAccessStep Represents a step in the SQL Server 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 or offline state.
Public class SqlMoveSchemaStep Represents a step in the deployment plan that corresponds to an action to move an element from one schema to another.
Public class SqlPossibleDataLossError This class represents a warning from the SQL Server deployment engine where the potential for data loss was identified.
Public class SqlPrintStep A type of step in a SQL Server deployment plan that signifies a Transact-SQL PRINT statement.
Public class SqlRenameStep Represents a step in the deployment plan that renames an element.
Public class SqlSchemaDeploymentOptions Contains options that control deployment.
Public class SqlTableMigrationStep Represents a data motion step in a SQL Server deployment plan.

Enumerations

  Enumeration Description
Public enumeration DeploymentCollationPreference Specifies the collation to use when comparing the source and target models during deployment.