Sql100SchemaDeploymentOptions Class
Represents deployment options that are specific to SQL Server 2008.
Inheritance Hierarchy
System.Object
Microsoft.Data.Schema.Build.SchemaDeploymentOptions
Microsoft.Data.Schema.Sql.Build.SqlSchemaDeploymentOptions
Microsoft.Data.Schema.Sql.Build.Sql90SchemaDeploymentOptions
Microsoft.Data.Schema.Sql.Build.Sql100SchemaDeploymentOptions
Namespace: Microsoft.Data.Schema.Sql.Build
Assembly: Microsoft.Data.Schema.Sql (in Microsoft.Data.Schema.Sql.dll)
Syntax
'Declaration
<DatabaseSchemaProviderCompatibilityAttribute(GetType(Sql100DatabaseSchemaProvider))> _
Public Class Sql100SchemaDeploymentOptions _
Inherits Sql90SchemaDeploymentOptions
[DatabaseSchemaProviderCompatibilityAttribute(typeof(Sql100DatabaseSchemaProvider))]
public class Sql100SchemaDeploymentOptions : Sql90SchemaDeploymentOptions
[DatabaseSchemaProviderCompatibilityAttribute(typeof(Sql100DatabaseSchemaProvider))]
public ref class Sql100SchemaDeploymentOptions : public Sql90SchemaDeploymentOptions
[<DatabaseSchemaProviderCompatibilityAttribute(typeof(Sql100DatabaseSchemaProvider))>]
type Sql100SchemaDeploymentOptions =
class
inherit Sql90SchemaDeploymentOptions
end
public class Sql100SchemaDeploymentOptions extends Sql90SchemaDeploymentOptions
The Sql100SchemaDeploymentOptions type exposes the following members.
Constructors
| Name | Description | |
|---|---|---|
.gif "Public method") |
Sql100SchemaDeploymentOptions | Initializes a new instance of the Sql100SchemaDeploymentOptions class. |
Top
Properties
| Name | Description | |
|---|---|---|
.gif "Public property") |
AbortOnFirstError | Gets or sets a value that indicates whether deployment should stop when the first error occurs. (Inherited from SqlSchemaDeploymentOptions.) |
|
BackupDatabaseBeforeChanges | Gets or sets a value that indicates whether the update script should include statements to back up the database before the target is modified. (Inherited from SqlSchemaDeploymentOptions.) |
|
BlockOnPossibleDataLoss | Gets or sets a value that indicates whether the update script should block if data loss might occur. (Inherited from SqlSchemaDeploymentOptions.) |
|
BuildtimeContributorsMustExist | (Inherited from SchemaDeploymentOptions.) |
|
CheckNewConstraints | Gets or sets a value that indicates whether new constraints should be checked when deploying changes. (Inherited from SqlSchemaDeploymentOptions.) |
|
CollationPreference | Gets or sets a value that indicates how the collation should be handled when changes are deployed. (Inherited from SqlSchemaDeploymentOptions.) |
|
CommentOutSetVarDeclarations | Gets or sets a value that indicates whether the SETVAR declarations should be commented out in the generated synchronization script. (Inherited from SqlSchemaDeploymentOptions.) |
|
ComparerConfiguration | Gets the comparison filter. (Inherited from SqlSchemaDeploymentOptions.) |
|
CreateNewDatabase | Gets or sets a value that indicates whether to create a new target database during deployment. (Inherited from SchemaDeploymentOptions.) |
|
DatabaseSchemaProvider | Gets the database schema provider. (Inherited from SqlSchemaDeploymentOptions.) |
|
DeployDatabaseInSingleUserMode | Gets or sets a value that indicates whether update script should set the database to single-user mode. (Inherited from SqlSchemaDeploymentOptions.) |
|
DisableAndReenableDdlTriggers | Gets or sets a value that indicates whether Data Definition Language (DDL) triggers will be disabled and later re-enabled during deployment. (Inherited from Sql90SchemaDeploymentOptions.) |
|
DropConstraintsNotInSource | Gets or sets a value that indicates whether constraints that occur only in the target should be dropped when deploying changes. (Inherited from SqlSchemaDeploymentOptions.) |
|
DropIndexesNotInSource | Gets or sets a value that indicates whether indexes that occur only in the target database should be dropped when deploying changes. (Inherited from SqlSchemaDeploymentOptions.) |
|
DropObjectsNotInSource | Gets or sets a value that indicates whether to drop any objects in the target database that are not in the source database. (Inherited from SchemaDeploymentOptions.) |
|
EnforceMinimalDependencies | Gets or sets a value that indicates whether only minimal dependencies should be enforced when schemas are compared. (Inherited from SqlSchemaDeploymentOptions.) |
|
ExcludedModelElements | Gets or sets a list of model elements that the user has chosen to be excluded from the target database. (Inherited from SchemaDeploymentOptions.) |
|
ExcludedObjectTypesForSchemaCompare | Gets a read-only copy of the types that are excluded from Schema Compare. (Inherited from SqlSchemaDeploymentOptions.) |
|
ExtensionHandle | Gets or sets the extension handle for this extension. (Inherited from SchemaDeploymentOptions.) |
|
GenerateDatabaseOptions | Gets or sets a value that indicates whether the database options should be set in the update script. (Inherited from SqlSchemaDeploymentOptions.) |
|
GenerateDeployStateChecks | Gets or sets a value that indicates whether the update script should check the deployment state. (Inherited from SqlSchemaDeploymentOptions.) |
|
IgnoreAnsiNulls | Gets or sets a value that indicates whether the ANSI NULLS setting should be ignored when schemas are compared. (Inherited from SqlSchemaDeploymentOptions.) |
|
IgnoreAuthorizer | Gets or sets a value that indicates whether the authorizers will be ignored during deployment. (Inherited from Sql90SchemaDeploymentOptions.) |
|
IgnoreColumnCollation | Gets or sets a value that indicates whether column collations should be ignored when schemas are compared. (Inherited from SqlSchemaDeploymentOptions.) |
|
IgnoreColumnOrder | Gets or sets a value that indicates whether the order of columns in tables and views should be ignored when schemas are compared. (Inherited from SqlSchemaDeploymentOptions.) |
|
IgnoreComments | Gets or sets a value that indicates whether the comments should be ignored when schemas are compared. (Inherited from SqlSchemaDeploymentOptions.) |
|
IgnoreCryptographicProviderFilePath | Gets or sets a value that indicates whether the file path for the cryptographic provider will be ignored during deployment. |
|
IgnoreDdlTriggerOrder | Gets or sets a value that indicates whether the order of DDL triggers will be ignored during deployment. (Inherited from Sql90SchemaDeploymentOptions.) |
|
IgnoreDdlTriggerState | Gets or sets a value that indicates whether the enabled state of DDL triggers will be ignored during deployment. (Inherited from Sql90SchemaDeploymentOptions.) |
|
IgnoreDefaultSchema | Gets or sets a value that indicates whether the default schema setting will be ignored during deployment. (Inherited from Sql90SchemaDeploymentOptions.) |
|
IgnoreDmlTriggerOrder | Gets or sets a value that indicates whether the order of data manipulation language (DML) triggers should be ignored when schemas are compared. (Inherited from SqlSchemaDeploymentOptions.) |
|
IgnoreDmlTriggerState | Gets or sets a value that indicates whether an enabled state of DML triggers should be ignored when schemas are compared. (Inherited from SqlSchemaDeploymentOptions.) |
|
IgnoreExtendedProperties | Gets or sets a value that indicates whether extended properties should be ignored when schemas are compared. (Inherited from SqlSchemaDeploymentOptions.) |
|
IgnoreFilegroupPlacement | Gets or sets a value that indicates whether the placement of objects in filegroups should be ignored when schemas are compared. (Inherited from SqlSchemaDeploymentOptions.) |
|
IgnoreFillFactor | Gets or sets a value that indicates whether the fill factor for indexes should be ignored when schemas are compared. (Inherited from SqlSchemaDeploymentOptions.) |
|
IgnoreIdentitySeed | Gets or sets a value that indicates whether identity seed values should be ignored when schemas are compared. (Inherited from SqlSchemaDeploymentOptions.) |
|
IgnoreIncrement | Gets or sets a value that indicates whether identity increment values should be ignored when schemas are compared. (Inherited from SqlSchemaDeploymentOptions.) |
|
IgnoreIndexOptions | Gets or sets a value that indicates whether index options should be ignored when schemas are compared. (Inherited from SqlSchemaDeploymentOptions.) |
|
IgnoreIndexPadding | Gets or sets a value that indicates whether index padding should be ignored when schemas are compared. (Inherited from SqlSchemaDeploymentOptions.) |
|
IgnoreKeywordCasing | (Inherited from SqlSchemaDeploymentOptions.) |
|
IgnoreLockHintsOnIndexes | Gets or sets a value that indicates whether lock hints on indexes should be ignored when schemas are compared. (Inherited from SqlSchemaDeploymentOptions.) |
|
IgnoreLoginSids | Gets or sets a value that indicates whether the login security identifiers (SIDs) should be ignored when schemas are compared. (Inherited from SqlSchemaDeploymentOptions.) |
|
IgnoreNotForReplication | Gets or sets a value that indicates whether the NOT FOR REPLICATION values should be ignored when schemas are compared. (Inherited from SqlSchemaDeploymentOptions.) |
|
IgnoreObjectPlacementOnPartitionScheme | Gets or sets a value that indicates whether the placement of objects in a partition scheme will be ignored during deployment. (Inherited from Sql90SchemaDeploymentOptions.) |
|
IgnorePartitionSchemes | (Inherited from SqlSchemaDeploymentOptions.) |
|
IgnorePermissions | (Inherited from SqlSchemaDeploymentOptions.) |
|
IgnoreQuotedIdentifiers | Gets or sets a value that indicates whether the quoted identifiers setting should be ignored when schemas are compared. (Inherited from SqlSchemaDeploymentOptions.) |
|
IgnoreRoleMembership | Gets or sets a value that indicates whether role membership should be ignored when schemas are compared. (Inherited from SqlSchemaDeploymentOptions.) |
|
IgnoreRouteLifetime | Gets or sets a value that indicates whether the route lifetime setting will be ignored during deployment. (Inherited from Sql90SchemaDeploymentOptions.) |
|
IgnoreSemicolonBetweenStatements | Gets or sets a value that indicates whether semicolons between statements should be ignored when schemas are compared. (Inherited from SqlSchemaDeploymentOptions.) |
|
IgnoreStatisticsSample | Gets or sets a value that indicates whether the statistics sample should be ignored when schemas are compared. (Inherited from SqlSchemaDeploymentOptions.) |
|
IgnoreTableOptions | Gets or sets a value that indicates whether table options should be ignored when schemas are compared. (Inherited from SqlSchemaDeploymentOptions.) |
|
IgnoreUserSettingsObjects | Gets or sets a value that indicates whether the user settings objects should be ignored when schemas are compared. (Inherited from SqlSchemaDeploymentOptions.) |
|
IgnoreWhitespace | Gets or sets a value that indicates whether whitespace should be ignored when schemas are compared. (Inherited from SqlSchemaDeploymentOptions.) |
|
IgnoreWithNocheckOnCheckConstraints | Gets or sets a value that indicates whether a WITH NOCHECK statement on check constraints should be ignored when schemas are compared. (Inherited from SqlSchemaDeploymentOptions.) |
|
IgnoreWithNocheckOnForeignKeys | (Inherited from SqlSchemaDeploymentOptions.) |
|
IncludeTransactionalScripts | Gets or sets a value that indicates whether the update script should be transacted where it is possible. (Inherited from SqlSchemaDeploymentOptions.) |
|
NoAlterStatementsToChangeCLRTypes | Gets or sets a value that indicates whether ALTER statements will be used to change SQL CLR types. (Inherited from Sql90SchemaDeploymentOptions.) |
|
ScriptDatabaseCollation | (Inherited from SqlSchemaDeploymentOptions.) |
|
SerializationData | Gets or sets the options that will be serialized. (Overrides SqlSchemaDeploymentOptions.SerializationData.) |
|
SourceSetVariables | Gets the list of variables and their values for the source of the comparison. (Inherited from SqlSchemaDeploymentOptions.) |
|
TargetConnectionString | Gets or sets the connection string for the target database. (Inherited from SchemaDeploymentOptions.) |
|
TargetDatabaseName | Gets or sets the name of the target database. (Inherited from SchemaDeploymentOptions.) |
|
TargetSetVariables | Gets the list of variables and their values for the target of the comparison. (Inherited from SqlSchemaDeploymentOptions.) |
|
TreatVerificationErrorsAsWarnings | Gets or sets a value that indicates whether to treat all verification errors as warnings. (Inherited from SchemaDeploymentOptions.) |
|
UnmodifiableObjectWarnings | Gets or sets a value that indicates whether warnings should be generated for unmodifiable objects when deploying changes. (Inherited from SqlSchemaDeploymentOptions.) |
|
VerifyDeployment | Gets or sets a value that indicates whether to verify the deployment after it is completed. (Inherited from SchemaDeploymentOptions.) |
Top
Methods
| Name | Description | |
|---|---|---|
|
AddExcludedObjectTypeForSchemaCompare | Adds a new type to the list of types that are excluded from Schema Compare. (Inherited from SqlSchemaDeploymentOptions.) |
|
CreateCopy | Creates a replica of SchemaDeploymentOptions for SQL Server 2008. (Overrides Sql90SchemaDeploymentOptions.CreateCopy().) |
|
Equals | Determines whether the specified Object is equal to the current Object. (Inherited from Object.) |
.gif "Protected method") |
Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.) |
|
FlushExcludedObjectTypeForSchemaCompare | Clears the list of types that are excluded from Schema Compare, and adds ISqlDynamicColumnSource to that list. (Inherited from SqlSchemaDeploymentOptions.) |
|
GetHashCode | Serves as a hash function for a particular type. (Inherited from Object.) |
|
GetPropertyClassesToExcludeFromComparison | Returns the list of property classes that will not be compared. (Overrides Sql90SchemaDeploymentOptions.GetPropertyClassesToExcludeFromComparison().) |
|
GetRelationshipClassesToExcludeFromComparison | Returns the list of relationship classes that will not be compared. (Overrides Sql90SchemaDeploymentOptions.GetRelationshipClassesToExcludeFromComparison().) |
|
GetType | Gets the Type of the current instance. (Inherited from Object.) |
|
IsObjectTypeExcludedForSchemaCompare | Checks whether the given type is included in the list of objectTypes that are excluded from Schema Compare. (Inherited from SqlSchemaDeploymentOptions.) |
|
MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object.) |
|
OnExtensionHandle | Returns the TSqlParser. (Inherited from SqlSchemaDeploymentOptions.) |
|
OnInitialize | Retrieves server paths and sets up the source and target variables for database name, data path, and log file path. (Inherited from SqlSchemaDeploymentOptions.) |
|
SetExtensionHandle | Sets the value of the ExtensionHandle property and calls the OnExtensionHandle method. (Inherited from SchemaDeploymentOptions.) |
|
ToString | Returns a string that represents the current object. (Inherited from Object.) |
|
TryLoadSourceSqlCmdVariables | Loads the SourceSqlCmdVariables from the specified variables file. (Inherited from SqlSchemaDeploymentOptions.) |
|
TryLoadTargetSqlCmdVariables | Loads the TargetSqlCmdVariables from the specified variables file. (Inherited from SqlSchemaDeploymentOptions.) |
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.