Posted by Brian Cryer on 11/23/71 11:29
<le_mo_mo@yahoo.com> wrote in message
news:1129345377.971147.100230@f14g2000cwb.googlegroups.com...
>I was wondering if any body has used Internet as a WAN (Wide Area
> Network) to provide database access. I know about web services but I
> like to experiment with using Internet as a extended network (web
> server behind one router and database behind another). Any ideas on
> where to look for this?
>
> Thanks
Not the internet, but I used a wide area network a few years ago to
replicate a large SQL Server database across. The WAN ran at 64kbps, and it
struggled but we were replicating across half a dozen production sites.
So be aware that there may be a serious performance hit - it depends a lot
on the upload and download speeds at both ends of the connection and the
types of queries that you might be doing. Timeouts may also be an issue. Do
a serious assessment of the volumes of data you are likely to be moving.
As John has rightly pointed out, use a VPN.
Hope this helps.
--
Brian Cryer
www.cryer.co.uk/brian
[Back to original message]
|