Two way replication

Posted by Nidzaaaa on Server Fault See other posts from Server Fault or by Nidzaaaa
Published on 2012-12-14T10:06:03Z Indexed on 2012/12/14 11:06 UTC
Read the original article Hit count: 110

Filed under:
|

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 table I have in 1. DB

From server 2 I created subscription to pull all columns from table which is in server 1 DB

But now, I need to publicate one columns of 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 hope someone understood my problem and have an answer for me, thanks in advance...

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

© Server Fault or respective owner

Related posts about sql-server-2008

Related posts about sql