I want to create merge publication between Server A(publisher) and Client
B(subscriber) over Internet. However, because of the security reasons Server
A cannot be directly accessed over Internet. What is the solution for this
case?
If I seperate distrbutor from Server A and enable it to be accessed directly
over Internet and Client B subscribes through distrbutor can this be a
solution?
(VPN is not allowed)
Erkan,
as far as I understand, the merge agent will need connectivity between the
publisher and subscriber to read the MSmerge_contents and MSmerge_tombstone
tables on each box, and the absence of any connectivity will preclude this
from working. However, you could investigate republishing to achieve your
goal.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Monday, March 12, 2012
Replication over Internet
Labels:
clientb,
create,
database,
internet,
merge,
microsoft,
mysql,
oracle,
publication,
publisher,
replication,
security,
server,
sql,
subscriber
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment