Replication Data Considerations

SQL Replication

Replication

Replication Data Considerations

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. .