Triggers in Replication
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Triggers in Replication

  1. #1
    Join Date
    Jun 2006
    Posts
    12

    Triggers in Replication

    Hi,

    I created a database trigger to monitor changes made to a particular column in a table. My problem now is there is a request to add this trigger into a replicated environment. For example: Database A is replicated to Database B on a daily basis. I need to add this trigger into Database A and make sure the information from that trigger is replicated over to Database B as well.

    My question is:(please bear with me, I have not done replication of database before)
    1)Can I simply add a trigger into a database and not affect it's current setting.
    2)How can I do this replication of the trigger info thing.
    3)Can it work if I add a trigger in Database A and add another trigger in Database B?

    Please assist.

    Regards,
    MK

  2. #2
    Join Date
    Jun 2006
    Posts
    259
    What type of replication? Physical standby, logical standby, Streams , advanced rep?

  3. #3
    Join Date
    Jun 2006
    Posts
    12
    Hi,

    I sorry am not exactly sure what type of replication it is on but it is definately not streams as it is running on 8.1.7. It has quick and full replication. It involves structure synchronization and data synchronization. I hope this helps.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width