General information
Forum:
Microsoft SQL Server
Title:
Two way replication issues
Hello,
I am trying to perform 2 way replication in SQL 2000.
SERVERA = OrdersTable -> I want data to replicate to this server from SERVERB on UPDATE only.
SERVERB = OrdersTable -> I want data to replicate to this server from SERVERA on INSERT only.
This is what I have done.
I created a publication on SERVERA and in the article properties, I checked only INSERT.
Then I created a push subscription to SERVERB.
I then created a publication on SERVERB and in the article properties, I checked only UPDATE. Then I created a push subscription to SERVERA.
Is this the correct way to achieve my goal?
Thanks in advance.
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only