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 |
|
jwsantora1
Starting Member
1 Post |
 Posted - 2007-06-06 : 08:34:20
|
| Architecture question for anyone....We have a typical SQL Server 3-tier VB.net app running at corporate and want our customers to interact through a website. If we host the website on-site, we can simply access the DB; but if we host at a remote location and want the users to perform updates (think DHL, Wells Fargo, Amazon), we'll need replication with Peer-to-peer. Some basic questions: 1) is everyone doing it this way? 2) will we need a full time replication consultant to set this up, keep it up, and keep an eye on it (administering the 50 user, 200 table DB is relatively easy and we've not needed a DBA for the past 10 years). 3) we're not DHL or Amazon, we just want that kind of end user add/update/delete functionality...so transation rates will be miniscule. But still, the corporate site is constantly being updated so we'll need a fat pipe to the hosting service, etc... any thoughts on performance?any other tips on doing an installation like this?thanks in advancejohn |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-06 : 10:07:28
|
| Not sure if hosting company let you do that. |
 |
|
|
nadigarsoo
Starting Member
5 Posts |
|
|
|
|
|
Replication to Web hosting service