Hi, I would like to know if it is possible to fire a trigger in Firebird (After Insert or Update or Delete) that keeps track of inserts, updates or deletes from a given table and then take those changes and propagate them to another database.
For Example (MSSQL)
After deleting a row from [dbo.table1] the same row from TestDB2.table1 is deleted also
CREATE TRIGGER [TR2] ON TestDB1.table1
DELETE FROM TestDB2.dbo.table1
WHERE field1 = (SELECT field1 FROM DELETED)
My question is... I can do the same on a FireBird DataBase?