Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Hi to Impliment Bi-Directional Replication

Author  Topic 

sponguru_dba
Yak Posting Veteran

93 Posts

Posted - 2006-08-26 : 13:42:08
Hi every body

Can some help to impliment Bi-Directional Replication in SQL sever2000

I have one server at India and other server at US between those servers i have to impliment Bi derectional replicaation



Thnaks in advance



Rishi Maini SQL2K5 Admin
Yak Posting Veteran

80 Posts

Posted - 2006-08-27 : 10:22:48
Hi,

Go for Merge Replication. One Server in India and other in US, I am sure you must be having a low network bandwidth plus time zone difference issue. Keeping in mind the above scenario I would recommed Merge Replication. You can check Books Online to get more info about Merge Replication. Let me know if you need anything else. (Other option is Transactional Replication with Immediate/Queued Updating, but it requires more Network Resources)

Regards
Rishi
Go to Top of Page
   

- Advertisement -