IdentityRangeManagementOption Enumeration

Статья
12/15/2008

Enumerates options for managing identity column range assignments in tables published using merge replication and transactional replication with updating Subscribers.

Пространство имен: Microsoft.SqlServer.Replication
Сборка: Microsoft.SqlServer.Rmo (in microsoft.sqlserver.rmo.dll)

Синтаксис

'Декларация
Public Enumeration IdentityRangeManagementOption

public enum IdentityRangeManagementOption

public enum class IdentityRangeManagementOption

public enum IdentityRangeManagementOption

public enum IdentityRangeManagementOption

Members

Member name	Description
Automatic	Identity columns are marked as NOT FOR REPLICATION, and replication automatically assigns identity ranges.
Manual	Identity columns are marked as NOT FOR REPLICATION, but replication does not assign identity ranges.
None	Identity columns are replicated to the Subscriber as the base data type.

Замечания

Identity range management is supported for both merge and transactional replication with updating Subscribers.

You should use Automatic whenever possible.

Automatic identity range management behavior is set by specifying PublisherIdentityRangeSize, SubscriberIdentityRangeSize, and IdentityRangeThreshold.

Manual is only used for snapshot and transactional replication without updates at the Subscriber, peer-to-peer transactional replication, or if your application must control identity ranges programmatically. With this option, you must ensure that ranges are assigned to the Publisher and each Subscriber, and that new ranges are assigned if the initial ranges are used.

None is only recommended for indexed views and for backwards compatibility with earlier versions of Microsoft SQL Server.

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.

Платформы

Платформы разработки

Список поддерживаемых платформ см. в разделе Hardware and Software Requirements for Installing SQL Server 2005.

Целевые платформы

Список поддерживаемых платформ см. в разделе Hardware and Software Requirements for Installing SQL Server 2005.

См. также

Справочник

Microsoft.SqlServer.Replication Namespace
Article.IdentityRangeManagementOption Property

Другие ресурсы

Управление ограничениями, идентификаторами и триггерами с помощью параметра «NOT FOR REPLICATION»
Репликация столбцов идентификаторов

Поделиться через