Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  Merge replication and integrity

Author  Topic  BBBKY Starting Member 2 Posts Posted - 2005-02-15 : 15:15:10 I have a merge replication package that updates from the publisher to the Subscriber. It needs to run immediately due to the contents of the 5 tables (user)however in doing so in order to replicate with referential integrity and keep the foreign key relationships there would be in the neighborhood of 150+ tables invloved in the immedate update. I believe that best practice is to always keep the foregin key relationships on the tables but are there any arguments no to do it and just have the package ignore the messages during replication. I am concerned about what this might cause trying to extract data out of the subscriber? Thanks, BBBKY