Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 345
  • Last Modified:

Couple of Replication trigger Q's

This is all just theory for now - as we haven't yet begun to use Replication, but some questions have come up early in the design phase.

1) Does replication fire triggers on the destination table in the destination db ?

2) Are rows replicated one by one and each one fires the triggers, what happens with batch inserts ?

0
brettc
Asked:
brettc
  • 2
1 Solution
 
danblakeCommented:
1) It can be made to fire triggers in the destination db if data is replicated to the destination db.
(Most replication types create triggers on the destination tables and would normally not require all triggers at all sites)

2) Batch size is controlled by the distribution agent.
(It can be set to fire one row by row, but normally updates are sent as batchs, which depends on how you setup the system..)

0
 
danblakeCommented:
Any update ?
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now