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 Microsoft SQL Server 2005.
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(Sql90DatabaseSchemaProvider))> _
Public Class Sql90SchemaDeploymentOptions _
Inherits SqlSchemaDeploymentOptions
[DatabaseSchemaProviderCompatibilityAttribute(typeof(Sql90DatabaseSchemaProvider))]
public class Sql90SchemaDeploymentOptions : SqlSchemaDeploymentOptions
[DatabaseSchemaProviderCompatibilityAttribute(typeof(Sql90DatabaseSchemaProvider))]
public ref class Sql90SchemaDeploymentOptions : public SqlSchemaDeploymentOptions
[<DatabaseSchemaProviderCompatibilityAttribute(typeof(Sql90DatabaseSchemaProvider))>]
type Sql90SchemaDeploymentOptions =
class
inherit SqlSchemaDeploymentOptions
end
public class Sql90SchemaDeploymentOptions extends SqlSchemaDeploymentOptions
The Sql90SchemaDeploymentOptions type exposes the following members.
Constructors
| Name | Description | |
|---|---|---|
.gif "Public method") |
Sql90SchemaDeploymentOptions | Initializes a new instance of the Sql90SchemaDeploymentOptions 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. |
|
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. |
|
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.) |
|
IgnoreDdlTriggerOrder | Gets or sets a value that indicates whether the order of DDL triggers will be ignored during deployment. |
|
IgnoreDdlTriggerState | Gets or sets a value that indicates whether the enabled state of DDL triggers will be ignored during deployment. |
|
IgnoreDefaultSchema | Gets or sets a value that indicates whether the default schema setting will be ignored during deployment. |
|
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. |
|
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. |
|
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. |
|
ScriptDatabaseCollation | (Inherited from SqlSchemaDeploymentOptions.) |
|
SerializationData | Gets the options that should be serialized. (Inherited from SqlSchemaDeploymentOptions.) |
|
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 2005. (Overrides SqlSchemaDeploymentOptions.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 a list of the property classes that will not be compared. (Overrides SqlSchemaDeploymentOptions.GetPropertyClassesToExcludeFromComparison().) |
|
GetRelationshipClassesToExcludeFromComparison | Returns a list of the relationship classes that will not be compared. (Overrides SqlSchemaDeploymentOptions.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.