I'm using snapshot replication in SQL Server 7.0, and I discovered that the referential integrity defined on the source table is lost on the destination tables at the subscriber. I've selected the Include declared referential integrity on the primary keys option and the Enable relationship for replication option for each source table. How do I replicate referential integrity to the subscriber?
The Include declared referential integrity on the primary keys article option in SQL Server 7.0 supports copying only primary keys—not foreign keys—as constraints. One way to copy foreign keys is to manually create tables at the subscriber and select the Leave the existing table intact article option when you set up the publication. SQL Server 2000 supports propagating both primary and foreign keys through the Include declared referential integrity article option.