two way replication 
Author Message
 two way replication
I have two SQL 2000 server, one is distributor and publisher and other one
is subscriber. Is it possible to replicate data with each other. In my case,
one master database (the subscriber one) contains the data in head office.
The publisher one is handled by operator who enter the data daily. However,
data also enter in head office. I hope thata two server can synchronize with
each other. How to do it? Is each database role as distributor and
subscriber in same time? Thanks.


Sat, 15 Nov 2003 14:35:54 GMT
 two way replication

This scenario suits to merge replication. Any site either subscriber or
publisher has the right to update,edit,delete data and once they are
connected the database in all sites will be brought to a single state.


Quote:
> I have two SQL 2000 server, one is distributor and publisher and other one
> is subscriber. Is it possible to replicate data with each other. In my
case,
> one master database (the subscriber one) contains the data in head office.
> The publisher one is handled by operator who enter the data daily.
However,
> data also enter in head office. I hope thata two server can synchronize
with
> each other. How to do it? Is each database role as distributor and
> subscriber in same time? Thanks.



Sun, 30 Nov 2003 08:27:40 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Two ways replication

2. Replication in two ways

3. two ways using dataenvironments conflicts!

4. Other ways to identify/apply differences between two tables

5. Two ways to quote your query ?1

6. Replicating (two ways) from 60+ Servers to a Central Server using SQL Server 2000

7. Two ways to quote your query ?1

8. outer-join hack that works two ways--why?

9. Report prints two ways...

10. Merge replication both ways

11. New to replication ** Two-way transactional replication **

12. Retrieve data from two tables, from two databases, in two registered servers


 
Powered by phpBB® Forum Software