Re: two way replication

Tech-Archive recommends: Fix windows errors by optimizing your registry

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



"Tulasi" <Tulasi@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:26EF923B-4FD6-44CF-B8F5-D3E4FBE0838B@xxxxxxxxxxxxxxxx
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..




.

Relevant Pages

  • Re: What happened to my PKs????
    ... I only want my users to have the ability to run reports over this database, and I want this database in sync with my production database with as minimal latency as possible, that's why I chose Transactional Replication. ... I thought that setting the "Not For Replication" on identity columns caused the records to just be written from the Publisher to the Subscriber, that the identity column isn't incremented. ... As you want a reporting server then I'd seriously consider log shipping as it can have quite a low latency and Everything is transferred - inc permissions. ...
    (microsoft.public.sqlserver.replication)
  • Re: New Records printing on odd pages - Word 2000
    ... So if you convert one section break to an Odd Page one, ... >> What I have is a mail merged document which reads off an access ... >> According to the database, if one field is "1" for instance, then the ... >> into the document from the access database, ...
    (microsoft.public.word.docmanagement)
  • Re: MSDE General Questions
    ... The state of the subscription is tracked in a table in MSDE called ... transaction was last applied on the subscription database. ... No changes are logged in the subscription database on the MSDE database, ... The way to think about it is, with plain vanilla transactional replication, ...
    (microsoft.public.sqlserver.replication)
  • Re: Restoring A Publisher
    ... Let's assume we are talking about transactional replication. ... They have a database that ... but kicking users out of the reporting database to ... do the restore doesn't appeal to them. ...
    (microsoft.public.sqlserver.replication)
  • Re: how do i read odd numbered lines from a file
    ... can anyone tell me how to lines from a file which are odd numbered i.e. ... The right answer is to use a database. ... Skipping every other line as you read the file is trivial. ... you've seen an even or odd number of '\n' characters, ...
    (comp.lang.c)