Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Database sycronisation Expand / Collapse
Author
Message
Posted Thursday, September 12, 2013 8:54 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, September 2, 2015 6:39 PM
Points: 1,817, Visits: 822
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





Post #1494427
Posted Thursday, September 12, 2013 10:11 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 13, 2015 3:24 AM
Points: 48, Visits: 814
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?
Post #1494434
Posted Thursday, September 12, 2013 10:27 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, September 2, 2015 6:39 PM
Points: 1,817, Visits: 822
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





Post #1494436
Posted Monday, September 16, 2013 6:12 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, August 14, 2015 3:35 AM
Points: 2,849, Visits: 4,039
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
Post #1495028
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse