Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Two way replication issues
Message
From
26/05/2004 09:24:02
Alvin Lourdes
Children and Youth Services Cluster
Toronto, Ontario, Canada
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Replication
Title:
Two way replication issues
Miscellaneous
Thread ID:
00907316
Message ID:
00907316
Views:
34
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
Map
View

Click here to load this message in the networking platform