Help needed in SQL Server

Discussion in 'Programming' started by Pratul_09, Aug 25, 2009.

Thread Status:
Not open for further replies.
  1. Pratul_09

    Pratul_09 New Member

    Joined:
    Sep 16, 2007
    Messages:
    219
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    Navi Mumbai
    We have two SQL Server installations which are in different location (ie., 100 KM apart). Records are continuously being added and delete into the tables and we have good internet connectivity between them.
    Now my question is that how will we make them replicate to each other and what are the best options available to us in such a scenario. Is SQL Server okay or we must move to Oracle in this case. We just want that the records affected at one end be visible at the other.
    And what replication is suitable Merge, snapshot or transactional

    Note : Replication may take place 2 or 3 times in a day and not continuously.
     
  2. vamsi360

    vamsi360 Always confused

    Joined:
    May 10, 2008
    Messages:
    348
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    Garden City
    please refer the SQL Server forum at technet to get immediate answer
     
Thread Status:
Not open for further replies.

Share This Page