SQL Server Performance Forum – Threads Archive

Replication and HTTPS

Hi: I want to replicate a small database using snapshot replication via TCPIP to a server in another region.
I know it is possible to use FTP, but want to avoid this b/c of low-security. It was suggested that I try to use HTTP as the share snapshot folder location, and it would be authenticated using kerberos.
Anyone have experience w/this? If so, please explain how it could/would work and how to set it up. Thanks in advance!

Internet replication is usually done with a VPN setup between the two servers. I don’t see anything in BOL about replication over HTTP(s) endpoints…

thx for reply. Ok, well, I have IP address and a port. What else do I need?
How would the snapshot folder work as a shared resource?

OK, I’d appreciate if someone had any other ideas..
Anyway, if I use FTP does that require continuous connectivity between servers, or only during the actual replication and/or pull? Thanks!

I believe as of now you need to depend upon the third party tools to secure the layer of data transformation. Referhttp://www.itsecurity.com/asktecs/aug3301.htm fyi. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.

quote:Originally posted by sql_jr OK, I’d appreciate if someone had any other ideas..
Anyway, if I use FTP does that require continuous connectivity between servers, or only during the actual replication and/or pull? Thanks!

If you use FTP option I don’t think you need continuous connectivity between the servers.
It requires when your snapshot agent runs, if it is not available it will fail.
If you have un reliable connection you use one way merge replication… See the following url…
http://groups.google.com/group/micr…way merge replication&rnum=1#0ce858f83d582e81
Mohammed U.

]]>