开发者

SQL Server VPN Replication

开发者 https://www.devze.com 2022-12-15 16:40 出处:网络
I have a requirement to use Sql replication from a sql server 2005 instance to a Sql 2000 instance over a vpn.The vpn is permanent between the 2 sites and there are only a few tables that need replica

I have a requirement to use Sql replication from a sql server 2005 instance to a Sql 2000 instance over a vpn. The vpn is permanent between the 2 sites and there are only a few tables that need replicated. Can anyone give me any advantages/disadvantages of replication over vpn or any issues with replication betwe开发者_Go百科en SQL 2005 and Sql 2000.

Thanks


Well,

I think as long as the amount of data is not that much and speed is not a k.o. criteria, this will work from the networking point of view. I have several applications communicating via VPN which basically works smoothly, but of course latency is notably higher compared to nonVPN communication.

HTH

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号