Two way replication

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 ...

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.

StackExchange Database Administrators Q#30552, answer score: 5