Monday, March 12, 2012

Replication over the internet

I want to be able to replicate large volumes of data over the Internet
between SQL Server 2000 databases. The transmissions would be once per day,
need to be secure, and are to a location three time zones away.
What do you recommend for testing, security, support (the whole nine yards)?
TIA George
Ideally you should use a VPN for truly secure solutions. For testing you
would have to use representative loads and representative hardware. Support
is a tough one, as the problems you will see tend to be environment and
application specific.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"George Morton" <gmorton1@.optonline.net> wrote in message
news:k1GAd.18165$lU1.13967@.fe09.lga...
> I want to be able to replicate large volumes of data over the Internet
> between SQL Server 2000 databases. The transmissions would be once per
day,
> need to be secure, and are to a location three time zones away.
> What do you recommend for testing, security, support (the whole nine
yards)?
> TIA George
>

No comments:

Post a Comment