Question
How does replicate handles foreign keys?
Does Replicate supports delete cascade?
Answer
In general apply changes to tables with foreign keys is not supported.
However, since Replicate reads the db log to retrieve the change events, in case of delete cascade, since delete cascase is usually translated to a series of delete statements, on two tables, and those are written to the db log, Replicate will read those deletes and process them, like any regular deletes.
Replicate does not create the master-child relationship on the target. If that relationship is manually created on the target, Replicate is not aware of that. In this case, when a delete arrives for a row in the master, Replicate will delete it. If a delete cascade is automatically done (by the db, not by replicate), then when Replicate will try to delete the child rows, it will generate errors. in this case, Replicate should be configured to ignore those errors (no rows found for delete-->Ignore record)
