I'm having problem with transactional replication - to replicate referencial intergity as well. I have database with 360 tables with 416 FK constraints containing "enforce relationship for replication". I want to use the transactional replication as part of disaster recovery plan, but how can replicate referencial intergrity to the subsriber as well? Is enabling NOT FOR REPLICATION on every foreign key the only solution or it can be done in another way?
If the only solution for replication refencial intergrity to the subcriber is through NOT FOR REPLICATION, then which is the easiest way to enable NOT FOR Replication on every FK?