sql server replication: Hi Friends,
I have a db with more than 350 table, most of them have Relational Integrity
with PK and FK

we want to have this DB replication to another server.

What are the potential problems and solutions?
I had experienced problems and conflicts if db has Relational Integrity.

Thanks in advance,
Pat

Patrick,
what type of replication are you considering? In particular, are the
subscribers to be updating ones?
What problems have you experienced in the past?
rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com

(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

You may consider using the "NOT FOR REPLICATION" clause on your RI
definitions. The idea is that the integrity has already been enforced at the
subscriber or publisher so there is no need to enforce it again.

This will allow you to publish articles in multiple publications without
having to worry about the order that replication tries to inesert records.

[quoted text, click to view]