Have a look in the articles section of
www.replicationanswers.com - I have a posted up an
article there on just this topic.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

did Anyone implement Merge replication over internet? and wht were the results, i need a detailed procedure of implementing replication over internet, i have successfully implemnted on the LAN but its not working on internet, i'll be thankful if u guide me. i am using a 128 ISDN line. What i want to do is to replicate the subsciber (both push and pull) from the publisher. the subsciber IP is dedicated
i'll thankful if anone can help me in this matter

--

Hi Paul
Thanks for such a wonderful article, Actually I am facing a problem,
you could see it as I have posted it on the group.

Actulally some days before I was implementing merge replication over
internet, during that time I didn't even provide the netbios name of
the remote MSDE server on the subscriber MSDE server and it worked
fine.

but now on a new set of MSDE servers even if I enter all the
information as you said I could not even connect to the remote server
using osql facility.

Pls Pls Pls help me out I have already spent 3 days on this problem and
getting frustated with each passing moment.




[quoted text, click to view]



--
rdhar
------------------------------------------------------------------------
Posted via http://www.mcse.ms
------------------------------------------------------------------------
View this thread: http://www.mcse.ms/message1380734.html

Hi Paul
One more query if you could solve my doubt.

Actually while impletmenting replication over internet, I am plannin
to use dynamic filtering, Since we don't want to provide FT
information to over subscribers (which are obviously at distribute
locations).

So I am asked to make sure that Snapshot is applied manually at th
sbuscribers side, Since I am not having very much idea about how t
Create Dynamic snapshot and apply it manually, Plz guide me??

Is it that If I apply snapshot manually I'll not need to specify al
FTP related stuff???????



[quoted text, click to view]


-
rdha
-----------------------------------------------------------------------
Posted via http://www.mcse.m
-----------------------------------------------------------------------
View this thread: http://www.mcse.ms/message1380734.htm

For a manual snapshot, you don't need the FTP settings to initialize,
however, any additional articles added to the publication will cause
problems.
I can't setthis up today, but if you're having problems with manual
application of dynamic snapshots, then yo could disable the dynamic snapshot
bit and have the filters applied to the whole snapshot. It ends up the same,
but will take longer.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Can you ping the remote server or probably ping is disabled so can you
telnet it using port 1433? IE is it 'visible' at all through firewalls.
Can you connect using the IP address in OSQL? If so, have you created the
client network alias?
Are you using a VPN? Is it FTP or fileshare initialization? Question for
initialization configuration.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)