Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.