Post reply

Database sycronisation

  • September 12, 2013 at 8:54 pm

    #282353

    Hi,

    looking for thoughts here please.

    I have a database 10GB in size that is used for scheduling. It runs on SQL 2008 R2 on a Windows 2008 R2 server. At most there are 20 users who use this. The problem now is some of those users are going up to a mine site where the link is over satellite so latency is rather large. They want to have a copy up on site that is synced with the head office and vice a versa at all times.

    Ideas thoughts ?

    Thanks.

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

  • September 12, 2013 at 10:11 pm

    #1649931

    I don't think the information you provided is enough to help you, do you want to do db synchronization or you've already setup replication and there is a delay?

  • September 12, 2013 at 10:27 pm

    #1649932

    Nothing has been set up. Im looking for ideas to see if this is possible. Replication the entire database with to ensure the two are in sync I don't think is a great solution. To m any tables etc.

    Let me know what other information you think you need.

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

  • September 16, 2013 at 6:12 am

    #1650392

    Ford Fairlane (9/12/2013)

    some of those users are going up to a mine site where the link is over satellite so latency is rather large

    Please elaborate.

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply