locked
Complicated Replication Architecture - Help Needed Please RRS feed

  • Question

  • We have 2 classified networks.  They will only connect with a VPN over fiber. 

    The two customers will not agree to directly connect their SQL Server databases to one another without having another server hop between them...on EACH side.

    What I'm looking at is this:

     

    SQL SERVER 2005 A

         |

         |

    DMZ

         |

         |

    SERVER AA

    |||||||||||| NETWORK A

    VPN LINK CONNECTS SERVER AA to SERVER BB

    |||||||||||| NETWORK B

    SERVER BB

         |

         |

    DMZ

         |

         |

    SQL SERVER 2005 B

     

     

     

    So as you see each SQL Server will never directly communicate with one another.   But they have a table that needs to be transactional replication in both directions.  If an app user gets added or his row updated/deleted in one database it needs to reflect in the other and vice versa.

     

    Can I get some guidance here please?  Like I said the transactions need to replicate fairly quickly (within 5 minutes at the outside, but quicker is better).

    Thanks

    Tuesday, April 12, 2011 9:38 PM

Answers