Replicating only one table, what's the best approach ?

• sherif_omar

  SSC Enthusiast

  Points: 100

  More actions

  April 6, 2008 at 1:12 pm

  #98922

  I have a single table on database A that needs to be replicated to two databases B and C in as-near-to-real-time as possible. The table is cleared every morning, and receives about 40,000 records per hour. Records are only added to the table, never updated or deleted.

  I'm wondering what is the best approach to replicate this table :

  1 - Transactional Replication

  2 - A trigger on the INSERT on table in A that then inserts the record into B and C

  3 - Timed jobs running on B and C that pull new records from A

  thanks all in advance.

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  April 7, 2008 at 3:23 pm

  #799462

  I would like to recommend LOG SHIPPING. Using triggers may result in performance headache when so many rows are added.