Wednesday, March 28, 2012

Merge Replication with Foreign Keys

I have a database with related tables by foreign keys (Not for Replication),
and I want to use Merge replication, is there any problem to keep the foreign
keys on both sides (publisher and subscriber) or I have to remove them?
Saeed,
you can keep them - as long as they have the NFR attribute.
If you are replicating a huge amount of data, there are issues, and this
article will help explain them:
http://support.microsoft.com/kb/308266/EN-US/
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
sql

No comments:

Post a Comment