I have two databases in different VAN’s. One in US and the other in India.
The requirement is to synchronize these two databases. If I add a record in
US database it should reflect in Ind database and vice-versa. I used
Transactionla replication, but facing issues with PK's.





I thought Transaction replication..but I am facing problems with PK’s..

use bi-directional transactional replication and have different seeds on
each side, even on one, odd on the other.

If the publisher is even make sure you reseed all identity tables to the
next even value if they are odd, and on the subscriber
make sure you reseed all identity tables to the next odd value if they are
even.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



[quoted text, click to view]