How would I set up secure replication between 2 servers that are in
different cities?

Would I need to define linked servers first?

Would I use SSL?

Help appreciated. Thanks.
Steve


*** Sent via Developersdex http://www.developersdex.com ***

[quoted text, click to view]

One approach would be to set up a VPN, which would avoid exposing your
MSSQL servers directly to the internet and secure the data as it's
transferred. Your replication implementation is probably a bigger
issue than the VPN, however - you should probably review the Books
Online information on replication to see which type is most suitable
for your needs first.

Replication is quite a big topic, so you might get better answers in
microsoft.public.sqlserver.replication.