Replication

  • I need to change an existing snapshot replication to Transactional replication. Is there a way to do this without having to create it transaction from scratch?

  • Transactional replication uses the snapshot agent to initialize the replication. There is no easy way around this.

    However the workload for this is not significantly greater than when applying snapshots as a part of snapshot replication.

    The main gotcha is the Transaction Log. This cannot be truncated until transactions can be applied to the distibution database.

    Therefore it grows while the Snapshot is being generated/applied.

    Ensure you have enough disk space available for this.

    Have a good read of BOL for Transactional replication and it tells you how to set it up.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply