Sql-server – Two way replication

replicationsql-server-2008

I have a little problem…

I have this case:

  • 2 server instances

  • 2 Databases

  • 1 Table (5 columns)

From server 1 I created publication to replicate all columns of tables I have in DB1.

From server 2 I created subscription to pull all columns from tables which is in DB1.

But now, I need to publish a column of the same table from server 2 to server 1 and also it has to be in same DB…

I tried with using logic and creating publication for server 2 and subscription on server 1 but there is error appearing:

You have selected the Publisher as a Subscriber and entered a
subscription database that is the same as the publishing database.
Select another subscription database.

I need it to be A to B and B to A replication

I hope someone understood my problem and have an answer for me.

p.s. Ask for more info if you need …

Best Answer

From your description it seems as if you require bidirectional replication. You may want to consider using Merge Replication, Bidirectional Transactional Replication, or Peer-to-Peer Replication.

I suggest reading through Selecting the Appropriate Type of Replication to see what type of replication best meets your application requirements.

Related Question