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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-10-23 : 09:30:38
|
| Jo writes "Hi,I have a challenging problem at hand. Currently, I havemade my applications (COMs, IIS webpages, etc.) to runon a local network and connect to SQL 2000 server on thesame network. So network speed/reliability is NOT an issue.Now, I am planning to make the same clients or middle tiercomponents to reside in another country (Asia/Europe) whilethe same SQL server and the existing applications remain in US. In other words, I have another deployment overseas but only want to main a centralized database in US.Can anyone advise on what is the best or commonly used strategy to perform read/write operations with the remoteSQL servers from applications abroad? Is it using MSMQ agood idea? Doing a VPN connection and making direct connection may be advisable as the Internet connection can be unreliable. Another way I can think of is having a low-end database at the remote locations (i.e. in UK/Asia) and then use SQL Replication to replicate read/write data tothe US database. What about others big e-commerce sites who have multiplewebsites such as Yahoo!? Is the database centralized?Any suggestions will be most appreciated. Please email meif you need more explanation of the setup I am discussinghere.Thanks in advance.Cheers,Jo (thamjy@ieee.org)" |
|
|
|
|
|
Connecting to a remote SQL server overseas.....how?