If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

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?

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.