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 |
|
rajani
Constraint Violating Yak Guru
367 Posts |
 Posted - 2008-09-16 : 16:53:10
|
| hi guys, need your expert advise on this.we've .net application that has sql server 2005 (standard edition) as backend. we've over 300 clients and many of them asking for replication for offline use of our app. we are looking for a generic solution to implement replication . can you advise how to set this up or some resources I can go thru ?Please let me know if I need to provide any more info to answer my question. thanks for your advise.Cheers |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-16 : 16:56:05
|
| How big is your database? what do you mean by offline use of our app? |
 |
|
|
rajani
Constraint Violating Yak Guru
367 Posts |
Posted - 2008-09-16 : 17:04:56
|
| sodeep,datbase can be very big (biggest so far is 100gb). offline use I mean , our clients are doctors and some times they go offsite for practice and want to access our app on their laptop. initially we thought we could ask users to remote login (i mean RDP,cisco etc.,) but many places these doctors go either internet is too slow or wont have any internet connections!to rephrase my question,how to implement replication in such mass scale efficiently. by the way many of these clients will not have any IT person to look after their databases so it's only us.so we want better/easier way of doing this.Cheers |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-16 : 20:27:16
|
| Search for " Merge Replication" |
|
|
|
homebrew
Posting Yak Master
114 Posts |
Posted - 2008-09-22 : 16:12:20
|
| Do they need the full 100G, or can they use just a small subset when they're on the road ? |
|
|
|
rajani
Constraint Violating Yak Guru
367 Posts |
Posted - 2008-10-07 : 15:47:08
|
| most probably full 100g. but we'll have to include an option to get subset of data also.Cheers |
|
|
|
|
|
|
need to advise on setting up replication