Results 1 to 5 of 5

Thread: SQL Syncronizer

  1. #1
    Join Date
    May 2003
    Location
    New York, NY
    Posts
    225

    Unanswered: SQL Syncronizer

    Are there any software packages that will keep two servers databases updated and syncronized with each other in real time? For example when a change is made on one server it is automatically changed on the other server and visa versa.

    Thanks,

    Mark

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54

  3. #3
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    Quote Originally Posted by Pat Phelan
    Merge Replication !

  4. #4
    Join Date
    May 2003
    Location
    New York, NY
    Posts
    225

    Question

    Thank you for your quick responses. We are using MSSQL 7.0 on both servers. I just gave it a quick read but will use transactional replication will the updates be instantaneous? Right now we have about 100 users hitting our main server what we want to do is have 50 users hit server 1 and the other 50 hitting server 2 and any updates or inserts be made on both servers. Is this the way to go?

  5. #5
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Based on your original description of what you want, Merge Replicaiton is exactly what you need. You can use transactional replication with updating subscribers, but that can get ugly with the 2pc problems that it induces and the issues with RPC performance.

    The short answer boils down to something like: Without knowing a lot about your setup (servers, network, clients, expectations, planned growth, etc) there is no way to give you a "rock solid" answer. Based on what you've expressed so far, Merge Replication would still be my suggestion.

    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •