This topic has not yet been rated - Rate this topic

Solution Design Considerations (Replication)

SQL Server 2008 R2

This section of the documentation covers areas that should be considered before implementing replication. In addition to these topics, the topic for each replication feature describes considerations for implementing the feature.

In This Section

Considerations for All Types of Replication

Includes information about: security and administrative considerations; data types and column types; and data integrity and conflicts.

Considerations for Snapshot Replication

Includes information about: creating and securing the snapshot folder; transferring and storing snapshot files; and scheduling snapshots.

An initial snapshot is typically applied for all types of replication, so you should be familiar with the considerations for snapshot replication even if you choose to implement transactional replication or merge replication.

Considerations for Transactional Replication

Includes information about: transaction log space; disk space for the distribution database; primary keys; triggers; and large object (LOB) data types.

Considerations for Merge Replication

Includes information about: the addition of a uniqueidentifier column to published tables; timestamp columns; large object (LOB) data types; and bulk inserting data into published tables.

Concepts

Replication Backward Compatibility

Other Resources

Designing and Implementing (Replication)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD