Replication Data Considerations

Replication Data Considerations

SQL Server 2000

Special considerations should be taken when publishing certain data types and properties. This section identifies those data types and properties, and it describes solutions for managing them, including:

  • Identity range management. Specifying identity range management can help you control how data modifications are made at different Subscribers during merge replication or during snapshot or transactional replication with updatable subscriptions.

  • Data types with specific uses. Different data types such as uniqueidentifier and timestamp have specific uses during replication processing, including conflict resolution when changes to the same data are made at multiple servers.

  • NOT FOR REPLICATION. Using the NOT FOR REPLICATION option allows you to implement ranges of identity values in a partitioned environment. .
© 2016 Microsoft