We have a merge replication setup with one publisher/distributor and several subscribers. Several of the tables being replicated have foreign key constraints and these replicate without issue. However, some foreign key constraints that utilize
cascading do not replicate. To make matters worse, some tables with these cascading fk constraints replicate fine while others do not. Has anyone run across this behavior and is there a fix for it? The cascades will dramatically reduce our
merge conflicts and help maintain the integrity of the data so we need to keep them in place.
View Complete Post