October 18, 2002 at 1:24 pm
What are my alternatives for replicating across the Internet?
I have SQL Server 7 setup on my web server with a port open for my server located on my companies network. I can successfully register the Internet SQL Server on my company server, but can not replicate like I could if it was a standard server on my company network.
Do I have to use FTP replication or create a VPN?
Why can't I replicate straight through TCP?
October 18, 2002 at 5:02 pm
You'll have use FTP for the snapshot (or FTP a backup, restore on subscriber first), but after that all it should take is connectivity. VPN a better choice, more secure, but most of are running TCP/IP networks internally and it works, external isnt much different. Just need to use sql logins instead of NT accounts for the connections.
Andy
October 22, 2002 at 5:16 pm
Can you provide more detail on this - what flavour replication?
Where does it fall down?
I have set up replication over the Internet using TCP/IP with no issues (other than security!)
Tim
October 23, 2002 at 4:32 am
Any type should work. Depending on bandwidth you may have a hard time getting your snapshot to complete in a decent amount of time and it may affect your latency as well. Plus you have to think about whether you may need to redo the snapshot at some point (agent fails for example) or you do a change where it would be faster to move the entire pub again than transmit the changes.
Andy
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply