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, April 16, 2014 9:57 PM
Points: 1,571, Visits: 690
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: Tuesday, January 07, 2014 8:13 PM
Points: 47, Visits: 807
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, April 16, 2014 9:57 PM
Points: 1,571, Visits: 690
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, March 14, 2014 2:19 AM
Points: 2,820, Visits: 3,916
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