Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hyperionfall
Starting Member
2 Posts |
 Posted - 2010-04-27 : 06:25:47
|
| Hello,I am currently using a front end back end access database. we use sharepoint to update and share and transfer reports and such. We also use sharepoint to synch some of the tables. I have convinced management that sharepoint is not the right medium for this and that we should consider migrating to something else. I would like to use sql server since i have a rudementary understanding of it through my access experience. However, my situation is as such. Many of my users are offshore and connection to the internet should be considered intermitent. Is sql server a viable solution that my off shore people could use the system off line and then "synch" on say a 24 hour basis? Each system would only update its own unique data such as quantities in the DB.thankslee leitner |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-04-27 : 06:44:39
|
| seems like what you're after is merge replicationhttp://msdn.microsoft.com/en-us/library/aa179416(SQL.80).aspx------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
hyperionfall
Starting Member
2 Posts |
Posted - 2010-04-27 : 06:58:28
|
| thanks that sounds like what i am looking for.I have 1 technical question about how it actually works. When SQL "synchs" "updates" the tables does it only transfer changes or is there a transfer of the entire tables? What I am looking for is how much data will be passed? The reason i ask is the connections available to the offshore systems is satelite based (1500ms latency) at either 128k or 256k bandwidth could bump up to 512 but that would be max. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
sql good for offline synch?