Results 1 to 10 of 10
  1. #1
    Join Date
    Jun 2006
    Posts
    66

    Unanswered: synchronizing 2 mssql databases

    I have 2 mssql databases on 2 different servers (not networked)
    How can I synchronize the 2 databases so changes done on both are automatically copied over?

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    If there is no connection between the two, then this can not be done automatically. Are the servers physically near each other? Can you carry a CD, or a USB key between them easily enough?

  3. #3
    Join Date
    Jun 2006
    Posts
    66
    no they are not near each other
    one is in our office and what the server that hosts are websites.

    Obviously i have access and uernames and passwords to both

    is there no options to do this?

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    If there is no "bridge" between them, then there is no way to do this.

  5. #5
    Join Date
    Jun 2006
    Posts
    66
    bridge meaning network??
    is there really no program that could do this?

  6. #6
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    If no one machine can connect to both SQL Servers at the same time, then the requirement is impossible. No program can do this.

  7. #7
    Join Date
    Jun 2006
    Posts
    66
    what do you mean by one machine?

    I can access both through the ip's and sql server authentication username and password.

  8. #8
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Then what do you mean by network?

    Can you connect to both SQL servers from your one desktop machine at the same time?

  9. #9
    Join Date
    Jul 2007
    Posts
    50
    I have used a program from xSQL. It has a Object and data comparison and will create scripts to ensure that the two databases are the same..

    I've only ever used the script on Objects, but I think the data one will do the same. Depends on how big the database's are I assume.

  10. #10
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    There are MANY caveats to this idea, but it sounds like you want merge replication. Think carefully about how you'll manage conflicts, this is definitely a non-trivial problem when dealing with an ISP.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

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