Triggers in Replication
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?
What type of replication? Physical standby, logical standby, Streams , advanced rep?
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.
Click Here to Expand Forum to Full Width