Replication across the internet

[scorpian]

Anyone have a good source how to set this up ? for SQL v7.

Thanks.

 

[Catadmin]

Across the internet? Ouch. I hope you have a T1 or better line. Otherwise it's going to be a pain.

Have you checked Books Online yet? Additionally, you're going to need a trusted connection between the servers and a connection that is always on, I believe. Look up Linked Servers for more details on this. Both SQL Server Agents will have to be running also and use the same login credentials for SQL.

Also, check out

http://msdn.microsoft.com/sql

which has lots of good white papers on this sort of stuff.



Catadmin - MCDBA, MCSA
Remember, "Work" is a four letter word. And you know what your mother told you about using four letter words!

 

[mrdenny]

There's nothing special to do when setting up replication over the internet. As long as your name resolution works correctly you should be fine.

Let me know if you have any specific questions or problems.

Denny

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)