Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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. .
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.