CreationScriptOptions 열거형

Enumerates schema option values for published articles.

이 열거형에는 해당 멤버 값에 대한 비트 조합이 가능한 FlagsAttribute 특성이 있습니다.

네임스페이스:  Microsoft.SqlServer.Replication
어셈블리:  Microsoft.SqlServer.Rmo(Microsoft.SqlServer.Rmo.dll)

[FlagsAttribute]
public enum CreationScriptOptions

멤버 이름설명
DisableScriptingObject creation scripts are not generated by the Snapshot Agent. You must specify a user-supplied script file to define the object at the Subscriber for CreationScript.
PrimaryObjectGenerates a creation script (CREATE TABLE, CREATE PROCEDURE, and so on) for the published object.
CustomProceduresIncludes the generation of custom stored procedures. This option is only valid for the TransArticle object. You must also specify InsertCommand, UpdateCommand, and DeleteCommand.
IdentityIncludes the creation of identity columns. This option is supported only for TransArticle objects and only for Microsoft SQL Server 2005 and later releases. For more information, see ID 열 복제.
KeepTimestampReplicates timestamp columns. Without this option, timestamp columns are created on the Subscriber as binary(16) columns. This option is supported only for TransArticle objects.
ClusteredIndexesIncludes the creation of a corresponding clustered index.
UserDefinedTypesToBaseTypesConverts user-defined data types columns at the Publisher to base SQL Server data type columns at the Subscriber. This option is not supported for non-SQL Server Publishers.
NonClusteredIndexesIncludes the creation of nonclustered indexes.
DriPrimaryKeyIncludes the creation of primary key constraints.
UserTriggersIncludes the creation of user-defined triggers.
DriForeignKeysIncludes the creation of foreign key constraints to all referenced tables that are included in the publication.
DriChecksIncludes the creation CHECK constraints.
DriDefaultsIncludes the creation column defaults.
CollationIncludes the definition of a column-level collation.
ExtendedPropertiesIncludes the extended properties associated with the database object being published.
DriUniqueKeysIncludes the creation of unique keys.
PrimaryKeyUniqueKeyAsConstraintsGenerates ALTER TABLE statements when replicating constraints.
MarkReplicatedCheckConstraintsAsNotForReplicationIncludes the NOT FOR REPLICATION clause when creating CHECK constraints so that the constraints are not enforced during synchronization. For more information, see NOT FOR REPLICATION으로 제약 조건, ID 및 트리거 제어.
MarkReplicatedForeignKeyConstraintsAsNotForReplicationIncludes the NOT FOR REPLICATION clause when creating FOREIGN KEY constraints so that the constraints are not enforced during synchronization. For more information, see NOT FOR REPLICATION으로 제약 조건, ID 및 트리거 제어.
FileGroupsIncludes the filegroups associated with a partitioned table or index.
참고참고

The underlying filegroup layout must be created at the subscriber before the initial snapshot is applied.

TablePartitioningSchemeIncludes the partition scheme associated with a partitioned table.
참고참고

The underlying partition scheme must be created at the subscriber before the initial snapshot is applied.

IndexPartitioningSchemesIncludes the partition scheme associated with a partitioned index.
참고참고

The underlying partition scheme must be created at the subscriber before the initial snapshot is applied.

StatisticsIncludes user-defined table statistics.
DefaultBindingsIncludes default bindings and creation of the bound defaults.
RuleBindingsIncludes rule bindings and creation of the bound rules.
FullTextIndexIncludes full-text indexes.
NoXmlSchemaCollectionsXML schema collections bound to xml columns are not included.
XmlIndexesIncludes XML indexes.
SchemaGenerates any schemas not already present on the subscriber.
XmlToNTextxml columns are replicated to the Subscriber as ntext.
MaxTypesToMatchingNonMaxTypesConverts nvarchar(max), varchar(max), and varbinary(max) to ntext, text, and image data types, which are supported on earlier versions of SQL Server.
PermissionsIncludes permissions defined on the published object.
AttemptToDropNonArticleDependenciesAt the Subscriber, attempts to drop dependencies to any objects that are not part of the publication.
FileStreamAttributeUse this option to replicate the FILESTREAM attribute if it is specified on varbinary(max) columns. Do not specify this option if you are replicating tables to SQL Server 2005 Subscribers.
NewDateTimeTypesToStringsConverts date and time data types (date, time, datetimeoffset, and datetime2) introduced in SQL Server 2008 to data types that are supported on earlier versions of SQL Server. For information about how these types are mapped, see the "Mapping New Data Types for Earlier Versions" section in 복제 토폴로지에 SQL Server의 여러 버전 사용.
StorageCompressionSettingReplicates the compression option for data and indexes. For more information, see 데이터 압축.
LargeUserDefinedTypesToVarBinaryMaxConverts common language runtime (CLR) user-defined types (UDTs) that are larger than 8000 bytes to varbinary(max) so that columns of type UDT can be replicated to Subscribers that are running SQL Server 2005.
HierarchyIdToVarBinaryMaxConverts the hierarchyid data type to varbinary(max) so that columns of type hierarchyid can be replicated to Subscribers that are running SQL Server 2005. For more information about how to use hierarchyid columns in replicated tables, see hierarchyid(Transact-SQL).
FilteredIndexesReplicates any filtered indexes on the table. For more information about filtered indexes, see 필터링된 인덱스 만들기.
FileStreamDataSpaceSet this option to store FILESTREAM data on its own filegroup at the Subscriber. If this option is not set, FILESTREAM data is stored on the default filegroup. Replication does not create filegroups; therefore, if you set this option, you must create the filegroup before you apply the snapshot at the Subscriber. For more information about how to create objects before you apply the snapshot, see 스냅숏 적용 전후에 스크립트 실행.
SpatialTypesToVarBinaryMaxConverts the geography and geometry data types to varbinary(max) so that columns of these types can be replicated to Subscribers that are running SQL Server 2005.
SpatialIndexesReplicates indexes on columns of type geography and geometry.
SparseAttributeReplicates the SPARSE attribute for columns. For more information about this attribute, see 스파스 열 사용.

The schema options for an article control how the published object will created at the Subscriber, and affect how the snapshot script files are generated. For more information, see 데이터 및 데이터베이스 개체 게시.

Values of the CreationScriptOptions enumeration are equivalent to values of the @schema_option parameter of sp_addarticle(Transact-SQL) and sp_add_targetservergroup(Transact-SQL).

The CreationScriptOptions enumeration supports the FlagsAttribute option which allows bitwise combination of enumeration values.

커뮤니티 추가 항목

추가
표시: