SQL 2 Way real time replication?

• Terry Kerns

  Newbie

  Points: 9

  More actions

  February 9, 2006 at 6:41 am

  #90677

  I have an interesting issue that I am not sure how to resolve. Our company has just moved to a new ERP package running on SQL 2000 SP4. At the Headquarters we have a clustered SQL Server using an HP MSA1000 SAN. We have recently acquired a company located in Florida that we want to move to our ERP Package. They have SQL 2000 SP4 there as well. We have attempted to run those users over our WAN connection with the front end package of the ERP Software and it is slow at best. What we would like to do is to install the ERP Software and Database in their location and have it mirror (Real Time Replication both ways) between the sites. Is this even possible? We have a 10Mbit VPN connection between the sites.

  Thanks and I look forward to any ideas anyone may have.

• Dave S

  SSC Enthusiast

  Points: 144

  More actions

  February 10, 2006 at 1:32 am

  #620031

  Terry,

   

  what erp package is it?

  we have an erp package based  sql 20000 but replication is impossible because the tables have no primary keys

  we do have multiway replication of our knowledge management system (sql2000) in place  across four sites two in europe and two in the US.

  regards

  Dave