2 way sync in SQL server 2005

Question

Post reply

2 way sync in SQL server 2005

Gangadhara MS

Hall of Fame

Points: 3377
More actions
July 3, 2013 at 1:39 am

#275719

Dear All,
I have a transactional replication from server A to B. But now for identity column of table at server B will going to insert and hence replication is failing.
I want to do the sync at 2 way ..meaning if any insertion happens at A should go to server B and if any insert at server B should go to server A.
Please suggest for 2 way sync with insert at both the side.
Thanks,
Ganga

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004434 More actions · Answer 1

The following MS link should help start you on your way.

http://technet.microsoft.com/en-us/library/ms151196.aspx

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jeff Moden SSC Guru Points: 1004434 More actions · Answer 2

Here's another decent one.

http://msdn.microsoft.com/en-us/library/ff649591.aspx

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)